IFERROR

[RhysBillOfficial]

Hi All,

I have been trying to use the iferror formula to show a certain number on my calculation.

CURRENT FORMULA: =((A1*A2+A3+A4))

The formula should display 25 if the sum is less than or equal to 24. I have tried to integrate iferror statement on that existing formula but can't seem to get it right.

Not sure if iferror formula is the best for this computation though.

Hoping for an answer.

#StaySafe

Kind Regards,
RhysBillOfficial

 

[Joe4]

IFFERROR checks for errors (i.e. trying to use text fields in a mathematical computation).
I think you can do what you want with the MAX function, i.e.

 =MAX(A1*A2+A3+A4,25)

 

[RhysBillOfficial]

Thank you so much @Joe4. That formula works!

stay safe

 

[Joe4]

You are welcome!