Solved using the if statement in excel

August 19, 2013 at 07:27:07
Specs: Windows 7
need if statement that says if n2 is 9000.00 or less, take N2 times 2.70%, if it is greater than 9000.00, then zero.
=if(n2<=9000.00,*2.70%, if>9000.00,0)

See More: using the if statement in excel

Report •

August 19, 2013 at 07:45:35
Correction: You need an if statement that says:
If N2 is 9000 or less:
•) Multiply N2 by 2.7%
•) Otherwise, zero.
=IF(N2<=9000, N2*2.70%, 0)

EDIT: ˅˅˅ It happens ˅˅˅

How To Ask Questions The Smart Way

message edited by Razor2.3

Report •

August 19, 2013 at 07:47:11
✔ Best Answer
Try this formula, it will check the value in N2 then accordingly multiply by 2.70% or just produce a Zero


Doh Razor got there before me

message edited by AlwaysWillingToLearn

Report •

August 19, 2013 at 08:54:34
That I have an additional issue....
I need this formula to also do the 2.70% on up to the 9000 for those over 9000.
I am trying to do a sheet for unemployment and I have done some basic if statements but this has to many returns for me!

Thank you so much .. spent an hour this morning doing this and I knew there was some simple thing I was doing wrong. Over thinking it!

Report •

Related Solutions

August 19, 2013 at 11:28:33
I'm not sure what you want as the final result.

Let's say N2 = 9200. I know you want to calculate 9000*2.7%, but what do you want done with the 200?

If all you want is a maximum of 2.7% of 9000, then either one of these should work:

=IF(N2>9000, 243, N2*2.7%)


=MIN(N2*2.7%, 243)

For N2 <=9000, you'll get N2*2.7%. For values > 9000 you'll get 243 which is 9000*2.7%.

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

message edited by DerbyDad03

Report •

Ask Question