Apache OpenOffice Community Forum • Creating Function - (View topic)

Page 1 of 1

Creating Function

Posted: 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

Posted: Fri Jan 25, 2019 5:02 pm

by FJCC

Code: Select all

=IF(A2 < 15;2.95;0.2 * A2)

Re: Creating Function

Posted: 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