Forum Discussion
Theodore G Kapela
Apr 04, 2023Copper Contributor
Excel 2016 formula Adding spreadsheetl data with negative number which needs to be made positive
Spread sheet In formula IMSUB ( F4,E5,G5 ) , sometimes Col E data may be negative, but the sum in Col J ( total kw usage for day ) , E5 has to added. Col E data comes from sum of daily meter rea...
Theodore G Kapela
Apr 04, 2023Copper Contributor
EDIT - E-5 in above , when negative, should be ignored. How to?