Help with Formula in excell 2007
 

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

Help with Formula in excell 2007
 

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

Help with Formula in excell 2007
 

so it worked or it didn't ??
who knows, who cares
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---