If function



0
In cell B1 if i need to display profit if profit value given in cell A1 is more than Rs. 500 if i want o display a flase result. how to write the formula

2 Answer(s)


0

Based on the value in A1, type the following formula in cell B1

=IF(A1>5000,"Profit","Loss")

0

=IF(A1>500,"FALSE")

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