Forum Discussion
rkolenda
Sep 02, 2020Copper Contributor
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 cert...
SqueakySneakers
Sep 02, 2020Brass Contributor
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.
- rkolendaSep 02, 2020Copper Contributor
Thank you so much SqueakySneakers
It works perfectly! I am learning as I go and hope to improve with time.