Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a tedious if statement to be made. What is an easier way of doing it.
If B2 is a or b or c or d or e or f, then a2 is XX if B2 is g or h or i or j, then a2 is YY if b2 is k or l or m or n or p, then a2 is ZZ if b2 is q or r or s or t then a2 is ab .. .. .. .. .. Is there a way or writing this in a if/or statement?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Renaming cells tedious and error prone | New Users to Excel | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Expediting Tedious Work | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |