 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008Help 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,  SignatureTraa Dy Liooar Jock Jock Formatted as windings 2 try this in G1 =IF(P1<>"","P","")&IF(T1<>"","P","") drag down as required Mike > 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, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.