bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
Hello all,
COL: G Has a range of values in multiples of 10 and ranges from 10 through 90.
COL: H Has a dollar value which shows negative and positive values.
COL: AD >> IF G2 = 10 or 20 and AD2 is < 0.00 put a 1 in the cell otherwise 0
This is the formula I put together but, the overall result is identifying information outside of this criteria.
=IF(OR(G2=10,G2=20,AND(AD2<0)),1,0)
Any help would be greatly appreciated
Bob
COL: G Has a range of values in multiples of 10 and ranges from 10 through 90.
COL: H Has a dollar value which shows negative and positive values.
COL: AD >> IF G2 = 10 or 20 and AD2 is < 0.00 put a 1 in the cell otherwise 0
This is the formula I put together but, the overall result is identifying information outside of this criteria.
=IF(OR(G2=10,G2=20,AND(AD2<0)),1,0)
Any help would be greatly appreciated
Bob