Forum Discussion

kb27batt's avatar
kb27batt
Copper Contributor
Sep 06, 2018

Using two formulas for one cell

Good Afternoon, 

 

I have been trying to figure out how to use the IF function for my problem, but I am having an impossible time.

 

I am trying to create an excel spreadsheet for my job. Depending on what type of evaluation I need to do, depends on how long I have to do it. If it's a new evaluation, I have 55 days to complete it, but 80 if its a renewal.  I have a column for the date of my meetings, a column that computes when my evaluation will be due, and a column that counts down the days I have left to complete it. 

 

For the column that computes when my evaluation is due, I want it to calculate the number of days based on the type of evaluation- ER stands for New and RR stands for a renewal.

 

My current formula is as follows : =[@[Re-Eval Meeting]]+80=(IF([@TYPE]="ER",[@[Re-Eval Meeting]]+55))

 

It comes up saying "FALSE". How Do I fix this so that it will Calculate my meeting date based on the Type column? Any help would be wonderful!

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    The syntax of the formula isn't correct, please try this one instead:

    =IF([@TYPE]="ER",[@[Re-Eval Meeting]]+55,[@[Re-Eval Meeting]]+80)

     

    Hope that helps

    • kb27batt's avatar
      kb27batt
      Copper Contributor

      I have been trying to figure that out for the last 2 hours. THANK YOU!

Resources