Help with Formula in excell 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bspadt - 25 Apr 2007 06:18 GMT

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

Reply to this Message

Max - 25 Apr 2007 07:32 GMT

Perhaps you mean in J3: =IF(I3<>"",MAX(F3,H3),"")

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message

Max - 26 Apr 2007 15:06 GMT

so it worked or it didn't ??
who knows, who cares

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message