Dear Excel Ninjas,
I'm looking to write a formula that ignores cells that have "NA" in them.
The exact formula is: =F8/((B8/B12)+(C8/C12)+(D8/D12)+(E8/E12))
The catch is that if any of those cells within the parenthesis have a value of "NA" then that divided pair should = 0.
So if B8 = "NA", B8/B12 = 0, or if B12 = "NA", B8/B12 = 0.
Would prefer to do this with an excel formula rather then a macro. Would appreciate any pointers.
Thanks in advance.
MattMax
I'm looking to write a formula that ignores cells that have "NA" in them.
The exact formula is: =F8/((B8/B12)+(C8/C12)+(D8/D12)+(E8/E12))
The catch is that if any of those cells within the parenthesis have a value of "NA" then that divided pair should = 0.
So if B8 = "NA", B8/B12 = 0, or if B12 = "NA", B8/B12 = 0.
Would prefer to do this with an excel formula rather then a macro. Would appreciate any pointers.
Thanks in advance.
MattMax