IF statement for personal template
I am looking for some advice on how to use a IF statement on a template that my team will use, but it needs to be set up part-way in the template.
For example, I want the column Quantity Budgeted to show a different number based on the selection in the Group column.
If the group column is Apple, I want Quantity Budgeted to show 4.00
If the group is Banana, The Quantity Budgeted to show 7.00
The # that will show is going to be different each time someone uses the template. That is what will be on a case-by case basis.
ALSO, there is another column that is using the number being populated in the Quantity Budgeted column.
Quantity Remaining column = Quantity Budgeted column minus Quantity (per month) column.
Help Article Resources
Check out the Formula Handbook template!