ExcelBanter - if formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if formula (https://www.excelbanter.com/excel-discussion-misc-queries/139473-if-formula.html)

Rynefan

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

T. Valko

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

Toppers

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

JE McGimpsey

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

fpa_177[_2_]

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

All times are GMT +1. The time now is 07:43 AM.