| Home > Forum Home > Automating Data Analysis Tasks > Multiple If condition > Multiple if condition | Share |
Multiple if condition
Excel Help for Multiple If Condition in Automating Data Analysis Tasks
| Forum Topic | Login |
Multiple If Condition | Rate this: (3/5 from 1 vote) |
 | You can use formula: =IF(MONTH(E2)<4,"Quarter 1",IF(MONTH(E2)<7,"Quarter 2",IF(MONTH(E2)<10,"Quarter 3","Quarter 4"))) this will give you the output "Quarter 1/2/3/4" according to the quarter to which it belongs Hope this information is useful Thanks Pooja | |
| PD | ||
| Posted by pooja_dubey12 on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Multiple if condition in the Excel Business Solutions Directory |