Help with IF(AND...

  • Thread starter Thread starter Jock
  • Start date Start date
J

Jock

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,
 
Jock

Formatted as windings 2 try this in G1

=IF(P1<>"","P","")&IF(T1<>"","P","")

drag down as required

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Macro Filter 2
Doubleclick 2
Filter 2
LOOKUP returning wrong values 2
Math help 3
Problem with a Array formula, Please help !! 6
Depedent Dropdown and INDIRECT($P$8) with a twist 4

Back
Top