Excel Help

[soapnumpty]

I'm trying to enter a formula where if the number in cell B139 is between 1 and 10,000, you enter 20% in cell F139, if it is between 10,001 and 20,000 you enter 25%, and so on. I can't work out how to do it. I've tried doing something like =IF(B139,1:10000,"20%") but this didn't work. And I've tried doing it as a LOOKUP table but wasn't sure how to set out the number ranges in the first column.

Can anyone help me please?

Many thanks.

[Old_Geezer]

I think you may need to use comparisons like > or

[Old_Geezer]

I have no idea why, after I type a couple of paragraphs, technology chooses to remove most of it once posted. Technology frustrates and stresses me so much !

[Old_Geezer]

Use comparisons such as > and <

Nest IF statements, i.e. put a further IF to work out, in the false field.

Make sure you have all the close brackets in place correctly.

[SeaJayPea]

Try this: In F139, type =IF(B139

[SeaJayPea]

Oh for crying out loud AB, what was that all about? Why've you deleted most of my post?

I'll try it again, I'm going to insert a load of spaces. If you use my formula, don't use any of them.

In F139, type the following "=IF(B139 < 10000,20, IF(B139 < 20000,25, IF(B139 < 30000,30,0)))

Then change the number format of cell F139 to Percentage. Should work.

[soapnumpty]

Brilliant, that has worked. Thanks very much all.