if sum or formula

[LanceLance]

Hi All,
I am trying to combine a If, Sum, Or statement and not having much luck
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=IF(A4=SUM($A$1+OR(0,1,2,3,4,5)),A3,A4)
<o> </o>
Basically what I am trying to do is: If cell A4 is equal to sum of Cell A1 plus either 1,2,3,4 or 5 then display what is in A3 if not A4
<o> </o>
Any help much appreciated.
<o> </o>
Lance

 

[Jonmo1]

Try

=IF(AND(A4>=$A$1,A4<=$A$1+5),A3,A4)

 

[PaddyD]

Hi.

You can't have a forumla in a4 refering to itself like that, but if you don't mind the calculation happening in another cell then:

=IF(OR(A1+{1;2;3;4;5}=A4),A3,A4)

...entered with control + shift + enter, not just enter.