excel formula needed

[Ish]

Hi

Can someone help me with this formula please.

I need a formula which does this:-

If A1=£100 to £199 then B2 should = A1 minus 35% and if A1=£200+ then B2 should = A1 minus 40%.

Thanks

 

[Jasebta]

I'm only a newb with excel, but I came up with =IF(A1>200,A1*0.6,A1*0.65)
If A1 is over 200 then it'll take the 40% off, if it's less than 200 it'll take 35% off. Not sure if that'll do for you!

 

[davethe11]

=IF(AND(A1>=100,A1<=199),A1*0.65,IF(A1>=200,A1*0.6,"SMALLER THAN 100"))

wasnt sure what you wanted to do if A1<100, so the formula outputs the string "SMALLER THAN 100"

if you just want A1 output in this case just change "SMALLER THAN 100" to A1


[edit] by the way, there are a few holes here, if your dealing with money, a figure of 199.99 will return "SMALLER THAN 100", but I made the equation to your exact spec, if you are only dealing with integers then no worries (if not, change A1<=199 to A1<200)

 

[Ish]

Thanks guys

yes the formulas do need to work with money figures.

i will test them out later.