Formula help

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
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,839
Office Version
  1. 365
Platform
  1. Windows
So if there isn't an entry, do you just not want to include that part in your calc?

If so, try converting each part like this:
change (1/C35)
to IF(C35,1/C35,0)
(repeat for each part)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,839
Office Version
  1. 365
Platform
  1. Windows
Barry,

Nice solution! I don't know why I didn't think of Arrays. It certainly does tidy the formula up a bit, doesn't it?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,448
Members
410,611
Latest member
JB_101920
Top