If functions

Hi Bina,

Thank you for your question.

A Nested If is used if you want to test a cell against multiple conditions.

An IF function only allows you to test a cell using one condition.

Here is an example:

=if(c5>100,50,if(c5>30,20,10))

I hope this answers your question.

Regards

Simon