Best Formula?

Discuss the spreadsheet application

Best Formula?

Postby quarkrad » Mon Apr 08, 2019 9:54 am

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 13 times
libreoffice 5.4.1.2 on ubuntu 16.04
quarkrad
 
Posts: 59
Joined: Mon Nov 03, 2008 10:01 am

Re: Best Forumla?

Postby Villeroy » Mon Apr 08, 2019 11:11 am

Attachments
t97629.ods
(10.61 KiB) Downloaded 15 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27111
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best Forumla?

Postby quarkrad » Tue Apr 09, 2019 8:54 am

Thank you very much and sorry for the late reply. That link is extremely useful.
libreoffice 5.4.1.2 on ubuntu 16.04
quarkrad
 
Posts: 59
Joined: Mon Nov 03, 2008 10:01 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests