Page 1 of 1

Creating Function

PostPosted: Fri Jan 25, 2019 4:57 pm
by aceandstormy
SOLVED!...Cell C has to be 20% of cell A...unless cell A is less than $15.00, Then cell C is $2.95...TIA!

Re: Creating Function

PostPosted: Fri Jan 25, 2019 5:02 pm
by FJCC
Code: Select all   Expand viewCollapse view
=IF(A2 < 15;2.95;0.2 * A2)

Re: Creating Function

PostPosted: Fri Jan 25, 2019 5:23 pm
by aceandstormy
=IF(A2 < 15;2.95;0.2 * A2) If I use this function but want a Zero when no info is present? As current function shows -$2.95...TIA