Creating Function

Talk about anything at all....

Creating Function

Postby aceandstormy » Fri Jan 25, 2019 4:57 pm

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
aceandstormy
 
Posts: 3
Joined: Fri Jan 25, 2019 4:09 pm

Re: Creating Function

Postby FJCC » Fri Jan 25, 2019 5:02 pm

Code: Select all   Expand viewCollapse view
=IF(A2 < 15;2.95;0.2 * A2)
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7058
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Creating Function

Postby aceandstormy » Fri Jan 25, 2019 5:23 pm

=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
aceandstormy
 
Posts: 3
Joined: Fri Jan 25, 2019 4:09 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 3 guests