Forum Discussion

JBird1295's avatar
JBird1295
Copper Contributor
Jan 05, 2024

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 h...
Formulas and Functions
  • djclements's avatar
    djclements
    Jan 05, 2024

    JBird1295 Try the following:

     

    =IF(F5<30, EDATE(G5, 3), IF(F5>59, EDATE(G5, 12), EDATE(G5, 6)))
djclements's avatar
djclements
Bronze Contributor
Jan 05, 2024

JBird1295 Try the following:

 

=IF(F5<30, EDATE(G5, 3), IF(F5>59, EDATE(G5, 12), EDATE(G5, 6)))
  • JBird1295's avatar
    JBird1295
    Copper Contributor
    Jan 05, 2024

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

     

Share