Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
58
Views
Topic starter
Is there a way to determine a formula on a condition?
I have built a table to track Restaurant, Groceries Gas/Fuel etc...
'=SUM([@[Tip_GR]]+[@[Sub_total_GR]])
If I go to a restaurant and give a tip it should add columns F and G
'=SUM([@[Gallans_GF]]*[@[per_Gal_GF]])
If I purchase Gas/Fuel I want it to multiply columns F and G
I am trying to merge these two table so I only have one table.
Posted : 10/05/2021 10:29 am
Hi Robert,
I think you should organize better the data table structure, it will allow you to view reports much easily.
See image attached, if it's properly organized, you don't have to use separate formulas.
Posted : 12/05/2021 12:00 am
