excel.advanced.course - Excel

Hi Jan

Thank you for your question.

I think you should be able to do this by setting your logical test to be X>0 (where X is the cell containing the number you are getting Excel to evaluate), then putting in what happens if X is >0 (i.e. positive) and what happens if X <0 (i.e. negative).

I hope this helps.
Amanda