If or if error function

Debbie Sin

Hi Community

I have three columns in the sheet, 1st one showing the entitle commission, 2nd one showing the commission paid date, the third one showing the commission due to paid, There are always an amount showing in Entitle Commission, If we have paid the commission, I will input the date on the commission paid date.  The   problem is here I would like to use the commission due to paid column to remind me to pay the invoice.  How can I use IF or IFERROR fomula to show that if the commission paid date column is blank, then the amount in Commission due to paid will be equal to Entitle Commission.  How can I make this happen

Thanks

 

Debbie 

Eid E. Eid

Let’s say A is your column for commission paid date

B is your column for Entitle commission

C is your column for Commissiom due

why don’t you try:

C=if(isblank(A),B,0)

I hope this works

 

good luck

Debbie Sin

It works, thanks so much