OR (IF) Function

[LJREdinburgh]

Hello,

I have a spreadsheet that is comparing quarterly figures in two separate columns. The IF Formula I have allows me to show increases and decreases with arrows formatting the cell with Wingdings3, however what the formula does not allow is to show no change as you can see in row two, both quarterly figures are 30%. The formula is returning a "q" now, and ideally I would want it to return "1". I assume this would be done with an OR, IF Formula, but I can't figure it out.

Thanks in advance

[TABLE="width: 500"]
<tbody>[TR]
[TD]43%[/TD]
[TD]46%[/TD]
[TD]=IF(R7>S7,"p","q")[/TD]
[/TR]
[TR]
[TD]30%[/TD]
[TD]30%[/TD]
[TD]=IF(R8>S8,"p","q")[/TD]
[/TR]
[TR]
[TD]22%[/TD]
[TD]18%[/TD]
[TD]=IF(R0>S9,"p","q")[/TD]
[/TR]
</tbody>[/TABLE]

 

[jasonb75]

Not, quite, the OR function would be used if you wanted the same result for different criteria.

You need

=IF(R7>S7,"p",IF(R7=S7,"1","q"))

Or an alternative method

=CHOOSE(SIGN(S7-R7)+2,"p","1","q")