Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums - D4 MINUS D3 EQUALS D5
I am trying to make a spreadsheet for mileage expenses for example if D4 is the amount i was paid and D3 is the amount of fuel i Paid for I need to know how much is left for wear and tear costs D5 I can not get this sum to work, can you help with the formula? eg: D4 =100 D3 = 50 D5 needs to automatically work out the difference so D5 = 50. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums - D4 MINUS D3 EQUALS D5
Put this in cell D5:
=sum(d4-d3) or even just =d4-d3 "Mark" wrote: I am trying to make a spreadsheet for mileage expenses for example if D4 is the amount i was paid and D3 is the amount of fuel i Paid for I need to know how much is left for wear and tear costs D5 I can not get this sum to work, can you help with the formula? eg: D4 =100 D3 = 50 D5 needs to automatically work out the difference so D5 = 50. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums - D4 MINUS D3 EQUALS D5
It's a "grade three" math
=D4-D3 "Mark" wrote: I am trying to make a spreadsheet for mileage expenses for example if D4 is the amount i was paid and D3 is the amount of fuel i Paid for I need to know how much is left for wear and tear costs D5 I can not get this sum to work, can you help with the formula? eg: D4 =100 D3 = 50 D5 needs to automatically work out the difference so D5 = 50. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: date field minus minutes equals new date | Excel Worksheet Functions | |||
how do I do this: today minus hire date equals how many years mo. | Excel Worksheet Functions | |||
2458.69 Minus 2458.69 Equals 0.0000000000135675 - Why? | Excel Discussion (Misc queries) | |||
if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) |