Forum Discussion
Reference issue perhaps? I need help please
I am having an issue as to figure out how to make this work. Any help would be appreciated.
I have certain numbers that refer to the measurement of my fence gate height(H") that I type in a certain cell (48,60,72 inches). The 48 and 60 inch numbers require 2 horizontal rails per gate as shown in pic. The 72 inch number requires 3 horizontal rails. This is the issue. How do I get the 72 to multiply by 3 per number of gate qty entered and still multiply by 2 when 48 and 60 is imputed?
2 Replies
Hi RK,
Assuming the gate H is in cell h3 and the gate quantity is in k3,
In the QTY cell put
= IF(OR(H3=48,H3=60),2,IF(H3=72,3,0))*K3
Adjust for you actual cells.
Thank you so much SqueakySneakers
It works perfectly! I am learning as I go and hope to improve with time.
