Help writing an Excel Formula
 

I'm trying to write a formula in Excel that will:

if d10 is less than 250 = $2.00. If d10 is equal to 250= $2.00. If d10
is greater than 250 then, divide d10 by 250 and multipy that number by
$2.00.

sounds easy but I'm not that familiar with writing formulas...
Thanks!!

"bella0711" wrote in message
oups.com...
I'm trying to write a formula in Excel that will:

if d10 is less than 250 = $2.00. If d10 is equal to 250= $2.00. If d10
is greater than 250 then, divide d10 by 250 and multipy that number by
$2.00.

sounds easy but I'm not that familiar with writing formulas...
Thanks!!

Will this do?
Put this =IF(D10="","",IF(D10<=250,2,D10/250*2)) in a cell other than d10
formatted as currency.

The formula would be
=IF(D10<=250,2,(D10/250)*2)
Hope that helps!
Amanda in Illinois

"bella0711" wrote:

I'm trying to write a formula in Excel that will:

if d10 is less than 250 = $2.00. If d10 is equal to 250= $2.00. If d10
is greater than 250 then, divide d10 by 250 and multipy that number by
$2.00.

sounds easy but I'm not that familiar with writing formulas...
Thanks!!

On 9 Sep 2005 07:31:19 -0700, "bella0711"
wrote:

I'm trying to write a formula in Excel that will:

if d10 is less than 250 = $2.00. If d10 is equal to 250= $2.00. If d10
is greater than 250 then, divide d10 by 250 and multipy that number by
$2.00.

sounds easy but I'm not that familiar with writing formulas...
Thanks!!

=if(D10<=250,2,D10/250*2)

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

The simplest formula would be:

=IF(D10250,((D10/250)*2),2)
and format the cell you put the formula in as currency.

"bella0711" wrote:

I'm trying to write a formula in Excel that will:

if d10 is less than 250 = $2.00. If d10 is equal to 250= $2.00. If d10
is greater than 250 then, divide d10 by 250 and multipy that number by
$2.00.

sounds easy but I'm not that familiar with writing formulas...
Thanks!!