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?

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password