| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use if statement for a #N/A cell
I have three cells A1 A2 and A3 In one or two of them there will be a value and in the third there will be a "not available" value. Iwant a fourth cell which will read the maximum of the two values, but should also take into account NA cell. (max) A1 A2 A3 A4 23 NA NA 23 24 36 NA 36 12 NA NA 12 14 24 12 24 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use if statement for a #N/A cell
This should work for you
=MAX(IF(ISERROR(A1),0,A1),IF(ISERROR(B1),0,B1),IF( ISERROR(C1),0,C1)) You need the ISERROR forumal to think N/A = 0 "noyau" wrote: I have three cells A1 A2 and A3 In one or two of them there will be a value and in the third there will be a "not available" value. Iwant a fourth cell which will read the maximum of the two values, but should also take into account NA cell. (max) A1 A2 A3 A4 23 NA NA 23 24 36 NA 36 12 NA NA 12 14 24 12 24 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use if statement for a #N/A cell
That is working, thank you.
"Cin" wrote: This should work for you =MAX(IF(ISERROR(A1),0,A1),IF(ISERROR(B1),0,B1),IF( ISERROR(C1),0,C1)) You need the ISERROR forumal to think N/A = 0 "noyau" wrote: I have three cells A1 A2 and A3 In one or two of them there will be a value and in the third there will be a "not available" value. Iwant a fourth cell which will read the maximum of the two values, but should also take into account NA cell. (max) A1 A2 A3 A4 23 NA NA 23 24 36 NA 36 12 NA NA 12 14 24 12 24 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use if statement for a #N/A cell
=MAX(IF(ISNA(A1:C1),"",A1:C1))
ctrl+shift+enter, not just enter "noyau" wrote: I have three cells A1 A2 and A3 In one or two of them there will be a value and in the third there will be a "not available" value. Iwant a fourth cell which will read the maximum of the two values, but should also take into account NA cell. (max) A1 A2 A3 A4 23 NA NA 23 24 36 NA 36 12 NA NA 12 14 24 12 24 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| insert date | Excel Worksheet Functions | |||
| Need help with an embedded IF statement | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
Linear Mode
