Problem with IF

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
Im having problems to go on the formula IF, here it comes

Cell E25 25000 and i have to make a sort of different sales commission's if this number increases as 26000 or more, the I have cels j42, 0% J43 5% and J44 7% what I need is to make the formula to select using the E25 number the proper % commission.
Thanks, Albert

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
your requirement is not very clear.

anyhow try this

In J42 this formula
=IF(E25>=26000,0%,"")

in J43
=IF(E26>=26000,5%,"")

inJ44
=IF(E27>=26000,7%,"")


if necessary modify the formula