IF statement formula

Topic

New Reply

I am trying to inset a IF statement that inserts 7% if cell is greater than 99999 and inserts 5% if cell is less than 100000. I would really appreciate any help.

Reply | Quote

Replies

I am trying to inset a IF statement that inserts 7% if cell is greater than 99999 and inserts 5% if cell is less than 100000. I would really appreciate any help.

Hi

I am confused on your requirement
if the cell >99999 and 99999 or < 100000, what result would you want?

Reply | Quote

Welcome to the Lounge!

Let’s say the cell with the number is A1.
The following formula, entered in another cell, will return 7% or 5% depending on the value of A1:

=IF(A1>=10000,7%,5%)

You may have to format the cell with the formula as a percentage.

Reply | Quote

Thanks Hans, that worked!!

Reply | Quote