Help with IF(AND...
Jock
Formatted as windings 2 try this in G1
=IF(P1<"","P","")&IF(T1<"","P","")
drag down as required
Mike
"Jock" wrote:
In any row, columns P and T may hold data.
In column G I am trying to put a 'tick' if there is data in P and two ticks
if there's data in both P and T.
By formatting G as Wingdings2, a P (capital letter) will appear as a tick.
There may be a better way.
Thanks,
--
Traa Dy Liooar
Jock
|