| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formula
=IF(C15D15,-5,5)
I am using the preceding formula. How do I change it to reflect the scenerio of "if c15=d15 than 0" ??? Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula
Try this:
=IF(C15=D15,0,IF(C15D15,-5,5)) Biff "Rynefan" wrote in message ... =IF(C15D15,-5,5) I am using the preceding formula. How do I change it to reflect the scenerio of "if c15=d15 than 0" ??? Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula
=IF(C15=D15,0,IF(C15D15,-5,5))
"Rynefan" wrote: =IF(C15D15,-5,5) I am using the preceding formula. How do I change it to reflect the scenerio of "if c15=d15 than 0" ??? Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula
One way:
=5*SIGN(D15-C15) In article , Rynefan wrote: =IF(C15D15,-5,5) I am using the preceding formula. How do I change it to reflect the scenerio of "if c15=d15 than 0" ??? Thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formula
Try =IF(C15d15,-5,IF(C15=D15,0,5)
"Rynefan" wrote: =IF(C15D15,-5,5) I am using the preceding formula. How do I change it to reflect the scenerio of "if c15=d15 than 0" ??? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
