Hi, I’m trying to write a formula but am struggling with it. I would like the following to happen.
B x C = E, but if A has ‘yes’ in the cell then I want the formula to go B x C x D = E
Can anybody please help. The formula I'm using is =IF(H22="yes",SUM(I22*J22)*K22)
A B($) C(qty) D(margin) E(total)
yes 100 2 1.5 230 If A didn't have 'yes' typed in then the total will be 200
Thanks for your help in advance.
Darren
Hi, welcome to the forum
maybe this?
=B*c*if(A="yes",d,1)
(you dont need to use SUM when multiplying cells/numbers together)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks Ford, really appreciate it. Works great!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks