Posted to microsoft.public.excel.misc

Rykar2

external usenet poster

Posts: 5

Help with nested formula

Hi,
Could you please help me with a formula for the following situation:
I have the amount of 20450.
(1-10000) at 30%
(10001-20000) at 27%
(20001-30000) at 24%
(30001-40000) at 21%
(Over 40001) at 18%
But if the result is less than 0 then I need the cell to show 0.
Is there a formula for this?
Thanks in advance.

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
Nested Formula - HELP	Gayla	Excel Worksheet Functions	13	March 20th 07 03:33 AM
Nested formula	PhillyD	Excel Discussion (Misc queries)	2	November 21st 06 10:06 PM
Nested Formula help	Pat Flynn	Excel Worksheet Functions	0	December 5th 05 04:25 PM
Nested Formula	MichaelS	Excel Worksheet Functions	6	November 28th 05 07:54 PM
Nested Formula	TheLeafs	Excel Worksheet Functions	1	July 11th 05 04:04 PM

All times are GMT +1. The time now is 04:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us