Forum home » Delegate support and help forum » Microsoft Excel Training and help » If formula
|
|
|
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. |
If formula
Resolved · High Priority · Version 2003
Reply Wed 10 Dec 2008, 16:40Delegate Mary said...
Mary has attended:
Excel Advanced course
If formula
how to write an if formula and rounding it at the same time
For upcoming training course dates see: Pricing & availability
RE: if formula
Hi Mary
Thank you for your question;
In answer I woul use something like this:
=IF(ROUND(B1,2) > 0,"Profit",IF(ROUND(B1,2) < 0,"Loss","Even"))
Which would round all values returned to the decimal point.
I hope that helped ... Pete
Wed 17 Dec 2008: Automatically marked as resolved.
|