Forum Discussion

Izzy0803's avatar
Izzy0803
Copper Contributor
May 25, 2022
Solved

Greater than and less than functions

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 ind...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 25, 2022
    so did you try =SUM( range ) - COUNT( range)*1.5
    or if you are really just interested in the Average then why not:
    =AVERAGE( range )
    or the difference from the target average:
    = AVERAGE( range ) - 1.5
mtarler's avatar
mtarler
Silver Contributor
May 25, 2022
so did you try =SUM( range ) - COUNT( range)*1.5
or if you are really just interested in the Average then why not:
=AVERAGE( range )
or the difference from the target average:
= AVERAGE( range ) - 1.5
Izzy0803's avatar
Izzy0803
Copper Contributor
May 25, 2022
=SUM( range ) - COUNT( range)*1.5
WORKS!
I really appreciate the help and knowledge

Resources