tallcoolpaul
New Member
- Joined
- Jun 12, 2008
- Messages
- 2
Hi I am using XL2003.
I have typed an if formula to flag up any cells that have 45 characters or more using
=IF(LEN(D:D)>45,"LONG","")
This is probably an obvious one but I can not work out how to do this for column d and column e. I assumed that if I put (D:D)OR(E:E) tha it might work but it doesn't. Please help as I am going crazy trying to work this out.
I have typed an if formula to flag up any cells that have 45 characters or more using
=IF(LEN(D:D)>45,"LONG","")
This is probably an obvious one but I can not work out how to do this for column d and column e. I assumed that if I put (D:D)OR(E:E) tha it might work but it doesn't. Please help as I am going crazy trying to work this out.