Ok, I'm making a spreadsheet which does simple stuff.

One of the boxes displays a word based on other conditions.
Here is the formula so far:

=IF(AND(D5=\"B\",F5E5),\"PROFIT\",\"LOSS\")

Which says If Cell D5 has the letter "B" in it AND the number in cell
F5 is greater than E5, then print "Profit", otherwise print Loss.

In the same box, I'd like to make another statement which says

If cell D5 = the letter "S" and F5 is less than E5, then Print
"Profit", otherwise print "Loss".

So the 1st statement will be connected to the 2nd statement with an OR
operator or something like that.
Therefore only one of these conditions is true.

Any idea how I can code it?


---
Message posted from http://www.ExcelForum.com/