| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Calculation
I need a calculation to do the following; If the value entered is above
£49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
=if(a149.99,2.40,(a1-10)*6/100) -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=563688 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
if you enter value in cell A1, try this =IF(A149.99,39.99*0.06,IF(A1<49.99,(A1-10)*0.06)) BrianC500 Wrote: I need a calculation to do the following; If the value entered is above £49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=563688 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
You have stated what you want done if the value entered is less than 49.99
and more than 49.99 but not what you want if the value is exactly 49.99. I suspect you mean less than 50 and equal or more than 50. A popular mistake. Would you let me know what you intended before I assume and put finger to keyboard. Regards. Bill Ridgeway Computer Solutions "BrianC500" wrote in message ... I need a calculation to do the following; If the value entered is above £49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
"BrianC500" wrote in message
... I need a calculation to do the following; If the value entered is above £49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated =6%*IF(A149.99,39.99,A1-10) -- David Biddulph |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
Thanks for the reply Bill.
The values are; "greater than 49.99" and "equal to or less than 49.99" Bill Ridgeway" wrote: You have stated what you want done if the value entered is less than 49.99 and more than 49.99 but not what you want if the value is exactly 49.99. I suspect you mean less than 50 and equal or more than 50. A popular mistake. Would you let me know what you intended before I assume and put finger to keyboard. Regards. Bill Ridgeway Computer Solutions "BrianC500" wrote in message ... I need a calculation to do the following; If the value entered is above £49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Calculation
Hi,
Thanks for that it really did help. I thought I might be able to adjust the figures for a similar calculation but, I am now getting a negative. Could you help again please? I now need the same calculation for; Value in cell A1 if greater or equal to 499.99 I need 6% of £449.99. If the value in A1 is less than £499.99 I need 6% of A1 less £50. If the Value in A1 is less than £50.00 I need a Zero. At the moment if I enter less than £50 I get a minus figure. Any help would be greatly appreciated. Thank you Brian "starguy" wrote: if you enter value in cell A1, try this =IF(A149.99,39.99*0.06,IF(A1<49.99,(A1-10)*0.06)) BrianC500 Wrote: I need a calculation to do the following; If the value entered is above £49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=563688 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Calculation of After tax Cost of debt Plz Help | Excel Worksheet Functions | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Formula calculation in a Shared Excel File | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
