Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|