Hello Everyone,
Please help. I have this problem in excel. I want to Multiply cell H6 to cell E6 if met a certain quantity. And Multiply cell H6 to D6 if met another certain quantity. I just don't know what formula to use.
Thank you very much!
Hello Everyone,
Please help. I have this problem in excel. I want to Multiply cell H6 to cell E6 if met a certain quantity. And Multiply cell H6 to D6 if met another certain quantity. I just don't know what formula to use.
Thank you very much!
It depends on how dynamic you want to make it, but to simply answer your question,
In cell I6 you can try this:
=IF(H$3=0.8,H6*E6,H6*D6)
and in cell I16, try this:
=IF(H$13=0.8,H16*E16,H16*D16)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks