| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
challenge formula
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
challenge formula
=ABS(A1*B1-C1) in D1
Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 21:17:01 -0700, Frances C wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
challenge formula
=IF((A1*B1)-C1<0,"error",((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 |
|
#5
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) | |||
![Frances C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
