| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,or IF--so sick of IF's
I want two IF's, not totally sure how to do it  =IF('6"PLANTS'!B23="XCANE", "XCANE", "-") or =IF('6"PLANTS'!B23="XTIP", "XTIP", "-") So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE, if it says XTIP I want it to say XTIP; Otherwise I want it to show "-". -- heathercor ------------------------------------------------------------------------ heathercor's Profile: http://www.excelforum.com/member.php...o&userid=35630 View this thread: http://www.excelforum.com/showthread...hreadid=554117 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should have when.. if, where..if,if..then..else with range | Excel Discussion (Misc queries) | |||
| template to track sick and vacation time for a year | Charts and Charting in Excel | |||
| Counting the number of times someone called in sick | Excel Discussion (Misc queries) | |||
| employee annual sick leave tracker with hours owing not used | Excel Discussion (Misc queries) | |||
Threaded Mode
