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)

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

Try this formula, it will check the value in N2 then accordingly multiply by 2.70% or just produce a Zero =IF(N2<=9000,N2*2.7%,0)

Doh Razor got there before me

message edited by AlwaysWillingToLearn

That works...now 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!

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%)

or

=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.

Ask Your Question

Weekly Poll