ariel20029
Board Regular
- Joined
- Jun 20, 2013
- Messages
- 97
Hi ,
I am getting an error message in excel with this formula. Can you please help.
1st its looking to see if it is a duplicate row and returning 0 if so
2 its looking to see what quarter the order falls in and if the end date is after the quarter then return 100000 else 0.
thanks,
Sharon
=IF(AS31="DUP",0,IF(BB31>=1,0,IF(AND(C31="2014-Q1",R31>= DATEVALUE("4/1/2015"),100000,IF(AND(C31="2014-Q2",R31>=DATEVALUE("7/1/2015"),100000,IF(AND(C31="2014-Q3",R31>=DATEVALUE("10/1/2015"),100000,IF(AND(C31="2014-Q4",R31<DATEVALUE("1/1/2016"),100000,0))))))
thanks,
Sharon
I am getting an error message in excel with this formula. Can you please help.
1st its looking to see if it is a duplicate row and returning 0 if so
2 its looking to see what quarter the order falls in and if the end date is after the quarter then return 100000 else 0.
thanks,
Sharon
=IF(AS31="DUP",0,IF(BB31>=1,0,IF(AND(C31="2014-Q1",R31>= DATEVALUE("4/1/2015"),100000,IF(AND(C31="2014-Q2",R31>=DATEVALUE("7/1/2015"),100000,IF(AND(C31="2014-Q3",R31>=DATEVALUE("10/1/2015"),100000,IF(AND(C31="2014-Q4",R31<DATEVALUE("1/1/2016"),100000,0))))))
thanks,
Sharon