Hi Friends
Good day all it's been a while just came back from my Leave with a bunch of work on my desk.
Please can anyone help with my formula I am trying to calculate and subtract using the IF formula but I guess I could not find my way around it.
What am trying to get is this
In Column D4 is the received Quantity of production
In Column D5 Is the consumed Quantity from the Actual received Quantity
In Column D6 is the Remaining Quantity after subtracting the Consumed from the actual received
Now i need a formula that will sum the received and the Remaining Quantity and subtract the Consumed but in Column M am getting an error.
Appreciate someone helping out with a better formula to go about this.
Regards
Good day all it's been a while just came back from my Leave with a bunch of work on my desk.
Please can anyone help with my formula I am trying to calculate and subtract using the IF formula but I guess I could not find my way around it.
What am trying to get is this
In Column D4 is the received Quantity of production
In Column D5 Is the consumed Quantity from the Actual received Quantity
In Column D6 is the Remaining Quantity after subtracting the Consumed from the actual received
Now i need a formula that will sum the received and the Remaining Quantity and subtract the Consumed but in Column M am getting an error.
Appreciate someone helping out with a better formula to go about this.
Regards
| 2023-Master Data Onshore Jetty Operation Tracking Update 2023.xlsx | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
| 1 | 4.546 | |||||||||||||||||
| 2 | 219.969 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 3 | Actual Supplied in Liters | 50,000.00 | 96,000.00 | 110,000.00 | 66,000.00 | 72,000.00 | 108,000.00 | 108,000.00 | 72,000.00 | 36,000.00 | 0.00 | 72,000.00 | ||||||
| 4 | Received in IG | 10,998.68 | 21,117.47 | 24,197.10 | 14,518.26 | 15,838.10 | 23,757.15 | 23,757.15 | 15,838.10 | 7,919.05 | 15,838.10 | |||||||
| 5 | Consumption In IG | 11,578.00 | 21,840.00 | 17,798.00 | 20,430.00 | 20,306.00 | 24,274.00 | 21,890.00 | 16,559.00 | 1,902.00 | 5,190.00 | 13,348.00 | ||||||
| 6 | ROB | 10,998.68 | 20,538.15 | 22,895.24 | 19,615.50 | 15,023.60 | 18,474.75 | 17,957.90 | 11,906.00 | 3,266.05 | #VALUE! | #VALUE! | #VALUE! | |||||
Bio_Diesel Consumption | ||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D4:R4 | D4 | =IFERROR(1/(1/SUM(D3/$C$1)),"") |
| D6 | D6 | =IF(D4=D4,D4-D5,IF(D4="",D5=D5,D5)) |
| E6:M6 | E6 | =IF(E4=E4,E4+D6-E5,IF(E4="",D6-E5)) |
| N6:O6 | N6 | =(N4+M6)-N5 |
