Best Formula?

Discuss the spreadsheet application
Post Reply
quarkrad
Posts: 68
Joined: Mon Nov 03, 2008 10:01 am

Best Formula?

Post by quarkrad »

The attached sheet shows what I'm trying to do. Column G shows the prices of all combinations of colums D, E and F. As a newbie I'm struggling with the appropriate formula to put in C32 to allow me to find the price. For example, 540 is the prices for 20 width, 40 length and made of brass. Any pointer would be greatly appreciated. I've been playing with INDEX and MATCH but not sure if it the right way to go.
Attachments
test.ods
(10.1 KiB) Downloaded 83 times
libreoffice 5.4.1.2 on ubuntu 16.04
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best Forumla?

Post by Villeroy »

Attachments
t97629.ods
(10.61 KiB) Downloaded 69 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
quarkrad
Posts: 68
Joined: Mon Nov 03, 2008 10:01 am

Re: Best Forumla?

Post by quarkrad »

Thank you very much and sorry for the late reply. That link is extremely useful.
libreoffice 5.4.1.2 on ubuntu 16.04
Post Reply