Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel.advanced.course - Excel
Resolved · Low Priority · Version Standard
Reply Wed 17 Oct 2007, 15:21Delegate Jan said...
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
Reply Thu 18 Oct 2007, 15:57Delegate Jan said...
RE: Excel
Many thanks
That works beautifully
|