| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!! |
|
#2
|
|||
|
|||
|
"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. |
|
#3
|
|||
|
|||
|
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!! |
|
#4
|
|||
|
|||
|
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 __________________________ |
|
#5
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Problem writing Excel formulas via ODBC | Excel Worksheet Functions | |||
| Problem writing Excel formulas via ODBC | Excel Discussion (Misc queries) | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
