| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula in excell 2007 | Excel Worksheet Functions | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| Excell 2007 Beta | New Users to Excel | |||
| Excell 2007???? | Charts and Charting in Excel | |||
| HYPERLINKS IN EXCELL 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
