Multiple Functions ?

  • Thread starter Thread starter Kyle Sweeney
  • Start date Start date
K

Kyle Sweeney

i need to make a function that will do three different things.

EX:
if B4 is less than 30 then = OK
if B4 is between 31 and 60 then = WARNING
if B4 is greater than 60 then = TROUBLE

I can do it to respond to 2 different actions but not three. This is what I
have now but it does not help for the third variable:
=IF(OR(B4<31),"OK","WARNING")

Can anyone help pleaseeeeeeee
 
That worked great.... can we take this one step further. What if instead of
numbers i wanted to use like
30% of 200. Would I just have to figure out what the number was myself then
do it like you posted earlier?
 
I'm not quite sure what you mean. Do you mean something like this...

=IF(N(B4)*N(C4),IF(B4<=30%*C4,"OK",IF(B4<=60%*C4,"Warning","Trouble")),"")

...where C4 holds a number like 200.
 
Domenic, (or group)
What does the N (as in IF(N(B4) represent in the formula? I ask few
questions but lurk here often to try to learn a bit. I don't recall seeing
the N previously. I don't have a problem understanding the formula other
than the letter N.
Thank you.
Ken

=IF(N(B4)*N(C4),IF(B4<=30%*C4,"OK",IF(B4<=60%*C4,"Warning","Trouble")),"")
 
Ken said:
What does the N (as in IF(N(B4) represent in the formula?
Click to expand...

The N() function returns the number the cell contains, which is
evaluated as TRUE, and returns 0 if the cell is empty or contains text,
which is evaluated as FALSE.

For more information, see the help menu under "Information Functions".
 
Thank you.
Ken



Domenic said:
The N() function returns the number the cell contains, which is
evaluated as TRUE, and returns 0 if the cell is empty or contains text,
which is evaluated as FALSE.

For more information, see the help menu under "Information Functions".
Click to expand...
 
Back
Top