Perhaps you mean in J3: =IF(I3<"",MAX(F3,H3),"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bspadt" wrote:
I am using columns F3, H3 I3 and J3. In column J3 my formula is =max(f3,h3)
which is what i need but I want a formula that if I3 has a value then J3
I3=max(f3,H3),I3_0,blank) but keep getting errors, I also tried 0 and none
where the word blank is in the previous formula. Any help would be
appreciated. Thanks