please edit the following question in the quiz 'how to use the MAX,MIN and IF function'



1
Q)In cell E1 you want to display "Profit" if profit value given in cell D1 is more than Rs 500 else you want cell E1 to diplay" False", how will you write this formula?
A) =if(E1>500, "Profit", "Loss")

=if(D1>500, "Profit", "Loss")

=if(D1>500, Profit, Loss)

1 Answer(s)


1

Q)In cell E1 you want to display "Profit" if profit value given in cell D1 is more than Rs 500 else you want cell E1 to display" Loss", how will you write this formula?