| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with blanks
Excel 2007
Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
=IF(A12=0,"",IF(A12=1,H12,"neither one or zero"))
You can replace "neither one or zero" with whatever you want in this situation... ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
Thanks Sheeloo, but what do I replace that with?
"Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
You can replace "neither one or zero" with whatever result you want from the
formula when A12 is neither one nor zero. You will doubtless have realised that the H12 in the formula should have been H5. -- David Biddulph Canon wrote: Thanks Sheeloo, but what do I replace that with? "Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
Thanks David for pointing that out... "David Biddulph" wrote: You can replace "neither one or zero" with whatever result you want from the formula when A12 is neither one nor zero. You will doubtless have realised that the H12 in the formula should have been H5. -- David Biddulph Canon wrote: Thanks Sheeloo, but what do I replace that with? "Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
Sorry guys, i'm not picking this up. I need cell C12 to pull the number from
cell H5 when cell A12 is 1, and cell C12 to be blank when cell A12 is 0 "David Biddulph" wrote: You can replace "neither one or zero" with whatever result you want from the formula when A12 is neither one nor zero. You will doubtless have realised that the H12 in the formula should have been H5. -- David Biddulph Canon wrote: Thanks Sheeloo, but what do I replace that with? "Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
Canon,
Use this in C12 =IF(A12=1,H5,IF(A12=0,"")) If A12 is 1 it will give you the value in H5, blank if A12 is 0, FALSE if it is neither 1 or 0 ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Canon" wrote: Sorry guys, i'm not picking this up. I need cell C12 to pull the number from cell H5 when cell A12 is 1, and cell C12 to be blank when cell A12 is 0 "David Biddulph" wrote: You can replace "neither one or zero" with whatever result you want from the formula when A12 is neither one nor zero. You will doubtless have realised that the H12 in the formula should have been H5. -- David Biddulph Canon wrote: Thanks Sheeloo, but what do I replace that with? "Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula with blanks
Yes, you'd already said that.
You said what you wanted if A12 is 0. You said what you wanted if A12 is 1. You *didn't* say what you wanted if A12 is neither 0 or 1. -- David Biddulph Canon wrote: Sorry guys, i'm not picking this up. I need cell C12 to pull the number from cell H5 when cell A12 is 1, and cell C12 to be blank when cell A12 is 0 "David Biddulph" wrote: You can replace "neither one or zero" with whatever result you want from the formula when A12 is neither one nor zero. You will doubtless have realised that the H12 in the formula should have been H5. -- David Biddulph Canon wrote: Thanks Sheeloo, but what do I replace that with? "Sheeloo" wrote: =IF(A12=0,"",IF(A12=1,H12,"neither one or zero")) You can replace "neither one or zero" with whatever you want in this situation... "Canon" wrote: Excel 2007 Looking for a formula that will do the follwing; If cell A12 equals 0 then cell C12 should be blank, if cell A12 equals 1 then cell C12 should equal the sum of cell H5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Blanks | Excel Discussion (Misc queries) | |||
| Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
| replace blanks using formula | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Linear Mode
