Home > Forum Home > Automating Data Analysis Tasks > Multiple If condition | Share |
Forum Topic | Post Reply Login |
Multiple If Condition | Rate this: (3/5 from 1 vote) |
I'd appreciate any help on this formula I'm working with. On Column E, I have dates. On column F, I need to have the Fiscal Quarters. So, if the date on E is between 4/1/08 and 6/28/08, column E should read Q1 and so on. So far I have this: =IF(AND(E2>4/1/8<6/28/8),"Q1",IF(AND(E2>6/28/8<9/27/8),"Q2",IF(AND(E2>9/27/8<12/27/8),"Q3",IF(AND(E2>12/27/8<3/31/9),"Q4",IF(AND(E2>3/31/9),"FY09/10",0))))) And no matter the date, the result I get on column F is FY09/10. What am I doing wrong? Thanks! | ||
Paula | ||
Posted by PaulaM on |
Replies - Displaying 1 to 4 of 4 | Order Replies By: Most recent | Chronological | Highest Rated |
Rate this: (3/5 from 1 vote) =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 |
Rate this: (3/5 from 1 vote) | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Rate this: (3/5 from 1 vote) Thanks for trying to help though! | |
Paula | |
Posted by PaulaM on |
Rate this: (3/5 from 1 vote) | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Displaying page 1 of 1 |
Find relevant Excel templates and add-ins for Multiple If condition in the Excel Business Solutions Directory |