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

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

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

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

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