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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History