Help with IF(AND...
 

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

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