Log In
Register
Home
Conditional Formula
Robert Prather
Active Member
Members
Forum Posts: 3
Member Since:
February 22, 2012
February 22, 2012
Offline1
May 10, 2021 - 12:29 am
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.
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1824
Member Since:
November 8, 2013
November 8, 2013
Offline2
May 11, 2021 - 2:00 pm
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Sherry Fox
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Purple RainbowBenefactor
MOTH Junkie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6350
Posts: 27773
Member Stats:
Guest Posters: 49
Members: 32317
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —