98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If formula
If formula
Resolved · High Priority · Version 2003
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
Thu 11 Dec 2008, 12:21Trainer Pete said...
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.
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 tip:Jumping Between Sheets in a BookPgDn and PgUp keys scrolls up and down a screen page in most applications. |
