| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
what i want to do is make a formule that will add £0.50 to any value over
£20.00 but to add £0.25 to any value under £20.00. i know it can be done but i can't remember how to do it |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
=IF(A1="","",IF(A1=20,A1+0.5,A1+0.25))
-- Regards, Peo Sjoblom Portland, Oregon "Paulo Coelho" <Paulo wrote in message ... what i want to do is make a formule that will add £0.50 to any value over £20.00 but to add £0.25 to any value under £20.00. i know it can be done but i can't remember how to do it |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I ADD AMOUNTS FOR DIFERENT VALUES
Hi Paulo,
if you have the £20.00 in cell A1 then go to cell b1 and enter: =IF(A1<20,A1+0.25,A1+0.5). Hope this helps ------------- Michael Gill - If you found this post useful please press "Yes" under the "Was this post helpful section" - Thanks :) "Paulo Coelho" wrote: what i want to do is make a formule that will add £0.50 to any value over £20.00 but to add £0.25 to any value under £20.00. i know it can be done but i can't remember how to do it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
| How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
Linear Mode
