This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to nest two different IF functions for a column in my spreadsheet.
The first (the prioritized function) would display "quarterly" in column H if column F displays "AM"
the second would display one year from the date in column H, however; I do not want cells with no date in column H populating the default date, so I have this part of the function written IF(G18="","",DATE(YEAR(G18)+1,MONTH(G18),DAY(G18)))
I've been playing with this thing for a while (i'm still very new to excel) and no dice.
My best attempt is: =IF(F18="AM","QUARTERLY",IF(G18="","",DATE(YEAR(G18)+1,MONTH(G18),DAY(G18))))
Any suggestions?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I just tried it again, same formula I wrote in the post. This time it worked. I couldn't tell you what the problem was before, but I tried it quite a few times.
Thanks for the help anyways though!
I must have done a typo, the date is supposed to populate in column H, one year from the date displayed in Column G.
It won't put "quarterly" in column H when I use my formula. Not sure what the problem is.
You write "one year from the date in column H", but your formula refers to column G. That actually makes more sense - a formula in H18 cannot refer to H18 itself.
What is the problem with the formula that you posted?