Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am having problems copying a formula result into another wksht if the
formula is not used...hard to explain... D10=Sum(A1:A5) I want to transfer D10 to wksht Data E12, however if there is no data in A1:A5, I want E12 to remain blank. It looks like it is reading the formula, so it places a "0" or a "-".... Any ideas? |
#2
![]() |
|||
|
|||
![]()
Tools - Options - View
Turn off zero values should get you part of the way. "Amanda" wrote: I am having problems copying a formula result into another wksht if the formula is not used...hard to explain... D10=Sum(A1:A5) I want to transfer D10 to wksht Data E12, however if there is no data in A1:A5, I want E12 to remain blank. It looks like it is reading the formula, so it places a "0" or a "-".... Any ideas? |
#3
![]() |
|||
|
|||
![]()
Amanda,
Try a formula like =IF(COUNT(A1:A5)=0,"",SUM(A1:A5)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Amanda" wrote in message ... I am having problems copying a formula result into another wksht if the formula is not used...hard to explain... D10=Sum(A1:A5) I want to transfer D10 to wksht Data E12, however if there is no data in A1:A5, I want E12 to remain blank. It looks like it is reading the formula, so it places a "0" or a "-".... Any ideas? |
#4
![]() |
|||
|
|||
![]()
Thanks! That worked!!
"Chip Pearson" wrote: Amanda, Try a formula like =IF(COUNT(A1:A5)=0,"",SUM(A1:A5)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Amanda" wrote in message ... I am having problems copying a formula result into another wksht if the formula is not used...hard to explain... D10=Sum(A1:A5) I want to transfer D10 to wksht Data E12, however if there is no data in A1:A5, I want E12 to remain blank. It looks like it is reading the formula, so it places a "0" or a "-".... Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
Trouble copying and pasting a formula | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |