Nesting IF formulas - Date Heavy

[Masugahau]

I am trying to create a budgeting workbook that would take data entered into one sheet and use it to complete sections of subsequent sheets. In this example, the sheet where data is entered is titled Instructions. To begin, users need to complete three fields on this sheet:

1. Field 1 is a dropdown where they will select how frequently they are paid (Weekly, Bi-Weekly, Monthly, or Twice a Month)
2. Field 2 is field to enter their next paydate
3. Field 3 is a field to enter the subsequent paydate after the next paydate

The sheet where data is being populated is called "Full Budget." On this sheet, I am attempting to populate pay dates based on the data entered on the Instructions sheet. I am trying to use a nested IF formula to calculate the dates. I was able to do so for instances where the selected pay frequency is Weekly, Bi-Weekly, and Monthly. Here is the formula I wrote and tested:
=IF(Instructions!C5="weekly",(A3+7),IF(Instructions!C5="bi-weekly",(A3+14),IF(Instructions!C5="monthly",(EDATE(A3,1)))))

This works correctly in my testing. I am running into trouble when I try to add the final IF formula - =IF(Instructions!C5="Twice a Month",Instructions!F4)
When I put this formula on it's own in a different cell, it calculates correctly. When I try to add it to my nested IF formula, it fails. The error I get is a standard "There's a problem with this formula." If I try to insert this section at the beginning of the nested IF formula, I get the #VALUE error.

I cannot figure out what I'm doing wrong here. Any suggestions?

 

[jasonb75]

Sounds like you just tried to put it the wrong side of a bracket or missed a comma.

=IF(Instructions!C5="weekly",A3+7,IF(Instructions!C5="bi-weekly",A3+14,IF(Instructions!C5="monthly",EDATE(A3,1),IF(Instructions!C5="Twice a Month",Instructions!F4))))

You will get #VALUE! if A3 contains anything other than a valid date.

 

[Masugahau]

Sounds like you just tried to put it the wrong side of a bracket or missed a comma.

=IF(Instructions!C5="weekly",A3+7,IF(Instructions!C5="bi-weekly",A3+14,IF(Instructions!C5="monthly",EDATE(A3,1),IF(Instructions!C5="Twice a Month",Instructions!F4))))

You will get #VALUE! if A3 contains anything other than a valid date.

THANK YOU! I still can't see it when I look myself, but your formula worked and saved my day!!