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 ???

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.

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History