Question

Observe the image and write a function to assign ‘Approved’ to all those who have a Total Monthly Expense less than or equal to 2500. It should also assign ‘Exceeds approved limit’ to those who have a total monthly expense of more than 2500. What will be the function

Answer 1

Answer:

=IF(D5>=2500,"Exceeds approved limit", " Approved")

where D5 cell is imagine as Total monthly expenses it is stored.