any excel whiz kids?
Thread Starter
Scooby Regular
Joined: Sep 2002
Posts: 2,551
Likes: 0
any excel whiz kids?
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
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
Joined: Nov 2001
Posts: 17,864
Likes: 0
From: Not all those who wander are lost
=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)
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)
Last edited by DJ Dunk; Oct 18, 2013 at 12:45 PM.
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
i.e. > 600 colour the field green
< 600 Colour it orange
< and 200 colour it red
dead easy to do, and looks better
Last edited by urban; Oct 18, 2013 at 05:32 PM.
Thread Starter
Scooby Regular
Joined: Sep 2002
Posts: 2,551
Likes: 0
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
bluebullet29
General Technical
9
Oct 5, 2015 02:17 PM
