Max Value of a cell
great thanks!!!!!
"Bob Phillips" wrote:
=IF(I19="yes",MAX(1000,D15/52*0.6),0)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"cwilliams" wrote in message
...
I tried
=IF(I19="yes",0)*AND(I20<1000,(D15/52)*0.6,"1000")
And this did not work either
|