Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
Dear
At this forumla " =ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2)" . I want the result as below. 1. Result = + is ok 2. Result = - show "o" Please advice how to add the command if result = "-", the number is show 0 Thanks 1111.com |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
One way,
Try: =MAX(ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2),0) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- wrote in message ... Dear At this forumla " =ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2)" . I want the result as below. 1. Result = + is ok 2. Result = - show "o" Please advice how to add the command if result = "-", the number is show 0 Thanks 1111.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |