Formulas that can work with different conditions

Ask the Community Formulas
#1

Hello Stackby community,

I am having a query while I was managing my payment records of my client,

Actually I have two columns

  1. Amount to be paid
  2. Amount paid

And in the third column, I am managing the STATUS of payment, if column2 value is greater than or equal to column 1, then status must be PAID else it must show UNPAID.

Can anyone help me out with this using the correct formula.

#2

Hi @Sqreder

You can use IF conditions in the Formula:

IF({column2}>={column1},”PAID”,”UNPAID”)

You can use normal IF conditions and nested IF conditions as well if you have multiple conditions you need to fulfil. Learn more about Nested IF formulas here.