Hi there
Can someone please help with a formula to work out prices on windows.
It is based on Width x Drop = $
0-595mm x 0-920mm = $106 (example 400x500=$106)
0-595mm x 921-1220mm = $111
596-811mm x 0-920mm = $121 (example 700x800=$121)
596-811mm x 921-1220mm = $126
All i want on an excel sheet are 3 fields, WIDTH DROP PRICE
I just cant seem to figure out how to imput the formulas.
Please help
Hello,
Assuming you have Width on A2, Drop on B2, you can paste this formula on C2
Please Login or Register to view this content.
(copy pasta from Ford)
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
Regards,
Lem
Or use a table
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Assuming Width on A2, and Drop on B2
C2: =LOOKUP(A2,{0,596},CHOOSE({1,2},LOOKUP(B2,{0,921},{106,111}),(LOOKUP(B2,{0,921},{121,126}))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks