View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bspadt Bspadt is offline
external usenet poster
 
Posts: 1
Default 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