StephenAnguiano
5 years agoQrew Cadet
Using Max in a If statement
I'm trying to set a max payout amount for my contractors and set the max amount at $3K. The following IF statement is still not working. My current data show the equipment - nominaltonnage to be 5 with a payout of $3750.
If([Customer - Related Client]=20 and ([Measure]="Replace On Burnout" or [Measure]="New Construction") and [MeasureDate]>=Date(2020,1,1) and [Equipment - SEERrange]>=18 and [Equipment - AC or Heat Pump]="GeoThermal",Max([Equipment - NominalTonnage]*750,3000))
Thanks
Stephen
------------------------------
Stephen Anguiano
------------------------------
If([Customer - Related Client]=20 and ([Measure]="Replace On Burnout" or [Measure]="New Construction") and [MeasureDate]>=Date(2020,1,1) and [Equipment - SEERrange]>=18 and [Equipment - AC or Heat Pump]="GeoThermal",Max([Equipment - NominalTonnage]*750,3000))
Thanks
Stephen
------------------------------
Stephen Anguiano
------------------------------