IF statement - Can it return a text and numeric response?

[TAPS_MikeDion]

Hi all,

I was unable to find an answer to this in my search of the forum. I realize this is probably one of the easiest questions to answer on here, but can the "value_if_true" or "value_if_false" in an IF statement be set up to return both a text and numeric response?

IF(logical_expression,value_if_true, value_if_false)

For example (and I know this syntax will return a formula parse error ),

=IF(H34>8,"OVERTIME = "H34-8,)

but can another formula be used to have the cell show either nothing (if false), or if true show "OVERTIME = " plus the value of a specified cell, minus 8?

Thanks,
Mike

 

[mumps]

Try: =IF(H34>8,"OVERTIME = "&H34-8,"")

 

[TAPS_MikeDion]

Told you that was going to be an easy one. LOL

Thanks mumps!

 

[mumps]

You are very welcome. Nothing is easy until you actually know how to do it!!!

 

[TAPS_MikeDion]

LOL
Yes, that's true.

BTW, for some reason there are certain rows that (using the formula you provided) return results like this: OVERTIME = 0.24999999999998

The cells are all formatted as "0.00" so this is driving me nuts trying to figure out why it's not just displaying the 2 digits after the decimal point. Actually, can the formula you provided be set up to round up so the end result is OVERTIME = 0.25?

Thanks again,
Mike

 

[mumps]

Try:
=IF(H34>8,"OVERTIME = "&(ROUND(H34,2)-8),"")

 

[TAPS_MikeDion]

Tada!

Thanks again mumps.

 

[mumps]

My pleasure.