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
=LOOKUP(LOOKUP(A2,{0,595,811},{1,2})&LOOKUP(B2,{0,920,1220},{1,2}),{"11","12","21","22"},{106,111,121,126})
(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