Hi,
I have a sheet where in four cells in a row is to be multiplied. As the data gets populated there can be a blank cell in same row but the formula should still calculate and give the results for three cells ignoring the empty cell as zero otherwise the entire result is shown zero since all the three cells are multiplied by zero.
Example
Row 1 data is A1=2, B1=3, C1=blank, D1=4 F1=2*3*blank*4=24
Row 2 data is A2=4, B2=blank, C2=5, D2=2 F2=4*blank*5*2=40
As shown above I need this type of calculation. What I am getting is zero in F column as C1 is blank in first row and B2 is blank in second row.
Why I want is so that excel should give me correct non zero result if I drag the cell formula to all below cells.
File attached with measurement sheet is where I want to work on.
Any help will be appreciated.
Thanks.
Bookmarks