Solved Excel Formula Help: IF Statement With Percentages

December 31, 2013 at 09:35:50
Specs: Windows 7
IF $500*3% IS GREATER THAN $20, $20, IF $500*3% IS LESS THAN $20, 3% HOW DO I DO THE FORMULA TO ENTER THIS IN MY SPREADSHEET?
A4 $500 B4 $20 C4 ???

See More: Excel Formula Help: IF Statement With Percentages

Report •


#1
December 31, 2013 at 11:24:58
First, a couple of posting tips...

1 - Please do not post in all caps. All caps is the internet equivalent of yelling, and nobody likes to be yelled at.

2 - When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Excel formula help needed" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Thank you for your understanding.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 31, 2013 at 11:33:59
✔ Best Answer
Is this what you are looking for?

IF(logical_test, [value_if_true], [value_if_false])

=IF(A4*0.03>20, 20, A4*0.03)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question