GREGGPRATT
New Member
- Joined
- Sep 27, 2006
- Messages
- 5
I have created the following formula:
=1/((1/C35)+(1/D35)+(1/E35)+(1/F35)+(1/G35)+(1/H35)+(1/I35)+(1/J35))
It works as planned, but want to know how to make this work if I have less than the 8 inputs. Sometimes my problems will only have 3 or 5 inputs. I get a division error now.
Thanks
=1/((1/C35)+(1/D35)+(1/E35)+(1/F35)+(1/G35)+(1/H35)+(1/I35)+(1/J35))
It works as planned, but want to know how to make this work if I have less than the 8 inputs. Sometimes my problems will only have 3 or 5 inputs. I get a division error now.
Thanks