Reference issue perhaps? I need help please

[rkolenda]

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]

@rkolenda 

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.

[#3]

Thank you so much @SqueakySneakers 

It works perfectly! I am learning as I go and hope to improve with time.