I am trying to create a formula for a monthly expense report using the following nested IF() statement:
=IF(B2="Weekdays", C2*20, IF(B2="Monthly", C2, IF(B2="Weekly", C2*4, IF(B2="Bi-weekly", C2*8, IF(B2="Bi-monthly", C2*2, "N/A") ))))
B column represents the recurrence of the expense and C column represents the value of the expense.
"N/A" as the
value_if_false to check that the formula was properly generating the monthly expense for each item.
I am getting
"N/A" back for a few of my expenses, but I don't understand why, since the rows which return
"N/A" have recurrences which were calculated elsewhere in the column. I have triple-checked spelling.
If anyone can identify a problem with my formula or an alternate, more concise formula, it would be greatly appreciated.