LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bella0711
 
Posts: n/a
Default 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!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel CHALLENGE...3 questions(indirect,rank,array formula)... Mlowry Excel Worksheet Functions 8 August 1st 05 07:34 AM
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM
Problem writing Excel formulas via ODBC srikantha Excel Worksheet Functions 1 June 21st 05 06:28 PM
Problem writing Excel formulas via ODBC srikantha Excel Discussion (Misc queries) 0 June 21st 05 08:24 AM
How do I get the formula bar in excel 2003 unionhall Excel Discussion (Misc queries) 1 February 17th 05 10:10 AM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"