May 25 2022 10:40 AM
I need a cell (J4) to calculate a range of cells (E4:E73) and show the result in cell (J4).
If the individual cells are greater than 1.5 it needs to add the value of leftover amount, also if the individual cells are less than 1.5 I need it to subtract 1.5
Thank you for any help you provide
May 25 2022 10:52 AM
=SUM(IF(E4:E74>1.5,E4:E74-1.5,E4:E74-1.5))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
May 25 2022 11:18 AM
May 25 2022 11:31 AM
May 25 2022 11:35 AM
=SUM(IF(NOT(ISBLANK(E4:E18)),IF(E4:E18>1.5,E4:E18-1.5,E4:E18-1.5)))
You can try this formula which seems to exclude blank cells in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
May 25 2022 11:37 AM
May 25 2022 11:46 AM
SolutionMay 25 2022 12:01 PM
May 25 2022 11:46 AM
Solution