Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Embedding IF: depends on result..
060628 Embedding IF: depends on result..
Hi, is there a way to modify the following equation, to reduce from 3 legs, e.g.: =IF(equation1,same eq*10,same eq*100) thanks to something like: =equation*10(or(if<1,if10),*10 again,"") otherwise nothing purpose - single digit view, on narrow column, 10 (or 95) goes to # sign custom format: # - same in other columns with much larger equations x 3 or 4 legs will be to much. ----- actual equations in formula vary, and do not matter, still all (ulitmately <1 & 10) =IF(OR(BR9={"",0},BR9<0.02),"",IF(((CI9-CG9)/((CH9-0.0001)-CG9))1, ((CI9-CG9)/((CH9-0.0001)-CG9)*10),((CI9-CG9)/((CH9-0.0001)-CG9)*100))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number into words | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |