Posted to microsoft.public.excel.worksheet.functions

Alabama

external usenet poster

Posts: 5

Nesting help

I am trying to nest the calculation of the gross up and the rounding,
following is an example as well as the formula that I am receiving the error
on, also I do not know why my final rounded figure did not round up to 34K?

Example:

Payment Gross Up Sum Rounded
32,549.00 976.47 33,525.47 30,000.00

=SUM(B2*3%,ROUND(B2,1-LEN(INT(B2))))

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
Nesting if/or/and	newdeas	Excel Worksheet Functions	4	July 19th 08 08:01 AM
Nesting	LWilson	Excel Worksheet Functions	12	May 9th 08 08:43 PM
Nesting	Donna	Excel Worksheet Functions	8	April 3rd 08 08:05 PM
OR Nesting?	Karel	Excel Discussion (Misc queries)	2	March 27th 08 03:52 AM
IF - Nesting... almost got it - need a bit of help	AngelaG	Excel Worksheet Functions	1	August 22nd 05 10:30 PM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us