Screenshot 2024-04-27 123630.jpg
Hi, I am trying to re-write a formula for K7. The formula in K7 works fine as long as I have data in F7 and J7 =SUM(F7*0.6 + J7*0.4). Where I am having problems is if F7 or J7 = 0. If either cell F7 or J7 equals zero, I would like to only use only the cell (F7 or J7) that has a numerical value for K7 instead of combining the percentage of F7 or J7 in K7.
With the following exceptions: if cell B7 is zero but C7, D7, or E7 have any values F7 will still be zero but and I would still like to apply it in the K7 formula. If B7 through E7 are Zero then K7 would equal J7.
The same exception with cell G7, if G7 is Zero but if cells H7 and I7 have numerical values other than zero I would like it to also apply in the K7 equation. If G7 through I7 are Zero then K7 would equal F7.
Hope this makes sense, thank you for any help.
Bookmarks