Scooby Soon!

I want a formula to take a number from a cell and if it is below a certain value display a value in the cell but if it is above a number display another different value in the cell


eg

If cell F5 has a value/number below 700 display the answer in the current cell as 100 but if F5 has a value/number above 700 display the answer in the current cell as 250

DJ Dunk

iTrader: (5)

=IF(F5<=700,100,250)

You didn't specify what happens if the value is exactly 700, so in this case if it's 700, the cell still displays 100.

If you want 250 to display when it's 700, then do:


=IF(F5<700,100,250)

urban

iTrader: (1)

Do conditional formatting instead, especially if you want to present some figures to someone.

i.e. > 600 colour the field green
< 600 Colour it orange
< and 200 colour it red

dead easy to do, and looks better

CREWJ

I agree with urban.

Although, it does depend on what you want from the data.

Scooby Soon!

I think this will work perfect, thanks I'm off to test....

bioforger

iTrader: (1)

it's all about the eye candy