Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

IF Function Formula Help

Copper Contributor

IF Function Formula Help

I am trying to create a spreadsheet for work:

I am trying to create a formula to calculate a date depending on a figure. I have almost got it but the last logic wont work. Help me I am pulling my hair out with it.

=IF(F5<30,EDATE(G5,3),IF(F5>29,EDATE(G5,6),IF(F5>59,EDATE(G5,12))))

Any suggestions greatly welcomed.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Re: IF Function Formula Help

@JBird1295 Try the following:

``=IF(F5<30, EDATE(G5, 3), IF(F5>59, EDATE(G5, 12), EDATE(G5, 6)))``

Re: IF Function Formula Help

AMAZING!!! Thank you! I will be able to sleep tonight now.

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

Re: IF Function Formula Help

@JBird1295 Try the following:

``=IF(F5<30, EDATE(G5, 3), IF(F5>59, EDATE(G5, 12), EDATE(G5, 6)))``