Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
I am trying to make a formula in one cell for example H22 but that
formula includes the value from G22 but G22 already has a formula in it. I need to tell H22 if G22 is<=0 make H22 blank. If not then add G22 and H21 together. Any help on this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
Hi
Try this in H22: =IF(G22<=0,"",G22+H21) Andy. "Dana" wrote in message oups.com... I am trying to make a formula in one cell for example H22 but that formula includes the value from G22 but G22 already has a formula in it. I need to tell H22 if G22 is<=0 make H22 blank. If not then add G22 and H21 together. Any help on this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
I get a #Value instead of a blank because the whole G column has a
formula already in it to get its value. This populates daily and if the day is tommorow then the next "G" stays blank but the H column is still trying to populate. I hope I am explaining this right...Sorry....Thanks for any more help you can give me. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
I get a #Value instead of a blank because the whole G column has a
formula already in it to get its value. This populates daily and if the day is tommorow then the next "G" stays blank but the H column is still trying to populate. I hope I am explaining this right...Sorry....Thanks for any more help you can give me. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
Hi
That could be because you are asking Excel if G22<=0, but G22 is text. Is that a possibility? Andy. "Dana" wrote in message oups.com... I get a #Value instead of a blank because the whole G column has a formula already in it to get its value. This populates daily and if the day is tommorow then the next "G" stays blank but the H column is still trying to populate. I hope I am explaining this right...Sorry....Thanks for any more help you can give me. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
G22 ends up a value from other values on other sheets.
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
So if you type =ISNUMBER(G22) in a cell what do you get? If you get a TRUE,
I'll have to look elsewhere, but I bet you get a FALSE!! Andy. "Dana" wrote in message ups.com... G22 ends up a value from other values on other sheets. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula including the value another formula gets
Try:
=IF(OR(LEN(G22)=0,G22<=0),"",G22+H21) "Dana" wrote: I get a #Value instead of a blank because the whole G column has a formula already in it to get its value. This populates daily and if the day is tommorow then the next "G" stays blank but the H column is still trying to populate. I hope I am explaining this right...Sorry....Thanks for any more help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
Sum formula is not adding up properly | Excel Discussion (Misc queries) | |||
Formula help : adding | New Users to Excel | |||
Adding a formula to a pivot table | Excel Discussion (Misc queries) |