Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Excel
excel.advanced.course - Excel
Resolved · Low Priority · Version Standard
Jan has attended:
Excel Advanced course
Excel
doing a conditional if then on whether a value is positive or negative
For upcoming training course dates see: Pricing & availability
RE: 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
RE: Excel
Many thanks
That works beautifully
|
