Posted to microsoft.public.excel.worksheet.functions

Frances C[_2_] Frances C[_2_] is offline

external usenet poster

Posts: 31

challenge formula

I will like to know if is posible to create a formula that can calcalculate
the following two problems

a1=200 * b1=2% - c1=o = result in D1 should be 4
a1=200 * b1=0% - c1=50 = result in D1 should be 150

Note the result can not be a negative number

Thanks

Frances

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
PLEASE HELP!!! Formula Question (Here's a challenge) :)	William@Target[_2_]	Excel Worksheet Functions	2	May 11th 07 07:11 PM
SUMPRODUCT formula challenge	Mitchell	Excel Worksheet Functions	3	October 11th 06 01:02 PM
Can this formula be created - Challenge	Brento	Excel Discussion (Misc queries)	0	June 20th 06 10:31 PM
Challenge experts will LOVE!!, Can you get the formula??	Drummy	Excel Discussion (Misc queries)	0	May 25th 06 07:17 AM
challenge! ISNA() and complex array formula	Lorin	Excel Discussion (Misc queries)	3	January 3rd 06 04:04 AM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us