# 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

#1
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 ˅˅˅message edited by Razor2.3

Report •

#2
August 19, 2013 at 07:47:11
 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 memessage edited by AlwaysWillingToLearn

Report •

#3
August 19, 2013 at 08:54:34
 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!

Report •

Related Solutions

#4
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%)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.message edited by DerbyDad03

Report •