LanceLance
Board Regular
- Joined
- Feb 4, 2009
- Messages
- 60
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-com
ffice
ffice" /><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
I am trying to combine a If, Sum, Or statement and not having much luck
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




=IF(A4=SUM($A$1+OR(0,1,2,3,4,5)),A3,A4)
<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


Any help much appreciated.
<o


Lance