Posted to microsoft.public.excel.misc

tarabull

external usenet poster

Posts: 21

Need help rounding up - THX Mike/Thomas for previous answer

One more question for you, if p53=2.35 but is not m53/.85, the if command
is still answering 2.35 since it ends in .05. How can I get it to go up to
2.40?

"Mike H" wrote:

Hi,

You don't need the quotes or the = sign

=IF(P53M53/0.85,P53,CEILING(P53,0.05))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need you Mike H!	jessshouse	Excel Worksheet Functions	4	June 28th 07 04:27 PM
Subtracting Dates - Mike	SJUCatch27	Excel Discussion (Misc queries)	4	June 18th 07 05:18 PM
rounding the answer of a formula	Boze	New Users to Excel	9	June 1st 07 08:14 PM
Usernames and Passwords--Thomas Homan	shannyshanhan	Excel Worksheet Functions	0	August 8th 06 06:22 PM
Mike	Window Menu Missing	Excel Discussion (Misc queries)	6	March 15th 05 03:49 PM

All times are GMT +1. The time now is 04:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us