Help

Re: Formula for applying a condition based on a Single Select options of another cell

365 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ghazi_Shah
4 - Data Explorer
4 - Data Explorer

Hi,
I’m setting up a bookkeeping system for my business.

What I need is that when I select the option “Expense” from the Single Select option in the Type field, I want to add a negative sign with the Received Amount field so that it is subtracted from the sum.
Airtablew

I’m attaching a screenshot for clarity.

I’d really appreciate it if someone can help me with the formula for this.

Thanks a lot :slightly_smiling_face:

1 Reply 1
augmented
10 - Mercury
10 - Mercury

Hi Ghazi. Try this…

IF({Type}='Expense', -1*{Total}, {Total})

Good luck.