| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
challenge formula
or you can use this
=ABS(A1*B1-C1) "Sunil Karnatki" wrote in message ... Use the goalseek function for the same. "Frances C" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PLEASE HELP!!! Formula Question (Here's a challenge) :) | Excel Worksheet Functions | |||
| SUMPRODUCT formula challenge | Excel Worksheet Functions | |||
| Can this formula be created - Challenge | Excel Discussion (Misc queries) | |||
| Challenge experts will LOVE!!, Can you get the formula?? | Excel Discussion (Misc queries) | |||
| challenge! ISNA() and complex array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
