ExcelBanter - formula that if ex. G4-G5 is less than zero = zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula that if ex. G4-G5 is less than zero = zero (https://www.excelbanter.com/excel-worksheet-functions/34457-formula-if-ex-g4-g5-less-than-zero-%3D-zero.html)

MAllen

formula that if ex. G4-G5 is less than zero = zero

N Harkawat

=min(0,g4-g5)

"MAllen" wrote in message
...

RagDyeR

Tim C

Just to be different:

=MAX(G4:G5)-G5

Tim C

"MAllen" wrote in message
...

All times are GMT +1. The time now is 09:02 AM.