One last request for a formulea

J

John Holt

Column G is the buy price, column H is the sell price, column J is the
profit and column K is the Loss, obviously column J is column H minus column
column G, how do I write a formulea for column K to show a value only when
column H is lesser in value than column G ie. a loss is made. I would like
column K to be blank if a profit is made and column J left blank if a loss
is made.
thank you in advance

John Holt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top