Forum Discussion
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...
- 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
It is to subtract from the cell value and if it is 1.5 it can be ignored too. I am calculating "bank time" for our pilots. They must fly 1.5 on average for each period they fly. So if they fly 1.3 it would be -0.2. Also if they flew 2.4 it would add 0.9