Hi,
>
> How can I use if and or scenario to get excel to 'ignore' if the cell has zero in column A or B, and just use the other yield with a % as my total yield.
>
> Column C is A * B.
>
> Thanks
>
> Yield 1*Yield 2*Total Yield
> 0%*100%*0%
> 99%*98%*97%
> 100%*0%*0%
> 95%*0%*0%
> 0%*85%*0%
> 100%*100%*100%
Bookmarks