How to create Multiple Conditional Formulas in a single cell?

[Guest]

How do I for create Multiple Conditional Formulas in a single cell?
For example:
=IF(B5<>0,IF(K5="Short",(L5-M5)*10000,(M5-L5)*10000),"") is one of the
equations, but I need it to multiply by 100 instead of 10000 if the answer is
greater than 1000.
I could also have it so it multiplies the different equation if word
criteria in a different cell from the same row is different. I dont know how
to do that either.

 

[Jim Rech]

I'm not sure what you're doing but it doesn't seem right for Conditional
Formatting. When you pick "Formula Is" in Format, Conditional Formatting
the formula you enter should return a True or False value. That result
determines whether the format you select is applied. You can return a
number but any non-zero number is considered True and of course, zero is
False. There is no point in returning a string like "".

--
Jim Rech
Excel MVP
| How do I for create Multiple Conditional Formulas in a single cell?
| For example:
| =IF(B5<>0,IF(K5="Short",(L5-M5)*10000,(M5-L5)*10000),"") is one of the
| equations, but I need it to multiply by 100 instead of 10000 if the answer
is
| greater than 1000.
| I could also have it so it multiplies the different equation if word
| criteria in a different cell from the same row is different. I dont know
how
| to do that either.

 

[JulieD]

Hi

if you mean the answer of L5-M5 is greater than 1000 it should be multiplied
by 100 instead of 10000 then:

=IF(B5<>0,IF(K5="Short",IF(L5-M5>1000,(L5-M5)*100,(L5-M5)*10000),IF(M5-L5>1000,(M5-L5)*100,(M5-L5)*10000)),"")

Cheers
JuileD