doing a conditional if then on whether a value is positive or negative

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

Many thanks
That works beautifully