How to create Multiple Conditional Formulas in a single cell?
 

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.

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
"Maxfx" wrote in message
...
| 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.

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-M51000,(L5-M5)*100,(L5-M5)*10000),IF(M5-L51000,(M5-L5)*100,(M5-L5)*10000)),"")

Cheers
JuileD

"Maxfx" wrote in message
...
| 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.