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")