| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pounds and pisters
YaSso wrote:
i want to make separated cells for pounds and pisters and sum the total of them.If pisters more than or equal 100 pisters, the integers automatically add to the sum of pounds. If your Pounds are in Column A and pisters (I am not familiar with that currency) in Column B use the following formula: =(SUM(A1:A6))+(SUM(B1:B6)/100) This will give pounds.pisters edvwvw -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200805/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Grams to Pounds | Excel Discussion (Misc queries) | |||
| How set up a spread in pounds & ounces? | Excel Discussion (Misc queries) | |||
| How do I add Pounds, Shillings and Pence? | Excel Discussion (Misc queries) | |||
| pounds multiplied by hours | Excel Worksheet Functions | |||
| How can I add pounds and ounces in excel, | Excel Discussion (Misc queries) | |||
Threaded Mode
