Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) | |||
Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |