RichKat
New Member
- Joined
- Nov 8, 2009
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
Hello,
I have two "Named Ranges" in the Name Manager that have the following Formulas:
Horiz10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!F7/10,0),0)
Vert10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!E7*2/10,0),0)
In Cell M50 I have SUM(Horiz10,Vert10) but the result is 0. Though when I put those formulas in two cells instead of in "Name" and sum the cells I get the correct result.
What Excel rule am I violating? Or how do I make this work?
Thanks a bunch!
Richard
I have two "Named Ranges" in the Name Manager that have the following Formulas:
Horiz10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!F7/10,0),0)
Vert10 contains: =IF(Summary!G7<=10,ROUNDUP(Summary!G7*Summary!E7*2/10,0),0)
In Cell M50 I have SUM(Horiz10,Vert10) but the result is 0. Though when I put those formulas in two cells instead of in "Name" and sum the cells I get the correct result.
What Excel rule am I violating? Or how do I make this work?
Thanks a bunch!
Richard
Last edited: