Previous Topic Next Topic

Problem with IF

Closed
Acendra - Dec 5, 2009 at 04:49 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2009 at 12:10 AM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 6, 2009 at 12:10 AM
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
0