Forum Discussion
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 AmairahSilver 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
- kb27battCopper Contributor
I have been trying to figure that out for the last 2 hours. THANK YOU!