| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help on SUMIF
working cells A31,B31,B32,B33. If B31A31,then B32 is (A31-B31)*8. If
B31<A31, then B32 is (9999-A31)+B31*8. I'm tryin to clock a electric meter that rolls around every 9999 units. After 9999, it starts on 1 again. I have other cells to covert data to money, but listing that right now would make things too complicated. My formula for B32 is =IF(B31A31,"SUM(B31-A31)*8","=SUM(9999-A31)+B31*8"). I can't get my orginal thought to pan out. On cell B33, I multiply B32 value by .01057 to convert to dollars. If you go from 9999 to 50, the difference is 9940. The real billing units are 51, because the meter ends at 10000. Any help greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| SUMIF Not | Excel Discussion (Misc queries) | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
