Solved Need help with If statement

June 2, 2016 at 08:15:37
Specs: Windows 7
I have the below statement established but now I need add a condition that says if it is not one of these two dates then I need it to leave the field blank.. I have tried just adding the , " " to the end but it doesn't like that..

=IF($AY$3=DATEVALUE("2/3/2017"),BD31-7, IF($AY$3=DATEVALUE("9/2/2017"),BD31-35))

I am on Excel 2013

See More: Need help with If statement

Reply ↓  Report •

June 2, 2016 at 08:23:25
✔ Best Answer
Try this and see how it works:

=IF($AY$3=DATEVALUE("2/3/2017"),BD31-7, IF($AY$3=DATEVALUE("9/2/2017"),BD31-35,""))


Reply ↓  Report •

June 2, 2016 at 08:47:07
Thanks Mike.. You are a super genius... One pesky parenthesis or comma in the wrong place and it freaks out..

Reply ↓  Report •

Related Solutions

Ask Question