| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
SORRY...REPLACE "A15" WITH "A1"
"danw" wrote: Try =IF(A15<100000,A15*0.15,IF(A15<250000,A15*0.12,A15 *0.1)) "Krista" wrote: I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop Excel interpretting a number range as a date? | Excel Discussion (Misc queries) | |||
| End of range changes when I add a number | New Users to Excel | |||
| how can I return a value in excel that looks at a range of number | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How to add one number to a range of numbers | Excel Worksheet Functions | |||
Threaded Mode
