Creating Function
-
- Posts: 3
- Joined: Fri Jan 25, 2019 4:09 pm
Creating Function
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!
Last edited by aceandstormy on Fri Jan 25, 2019 5:11 pm, edited 1 time in total.
open office 4 Vista
Re: Creating Function
Code: Select all
=IF(A2 < 15;2.95;0.2 * A2)
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 3
- Joined: Fri Jan 25, 2019 4:09 pm
Re: Creating Function
=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
open office 4 Vista