various conditions that have to be met in an if statement

**Manjula1** · 10-31-2012, 06:39 AM

Hi,
I have a spreadsheet, where there are
-hectares
-Price per ha
-Crop
-Row spacing (3Feet, 5Feet and 7Feet)

I have been able to calculte the following:
If the hectares is 0,0, If the crop is "Maize", then multiply 'Price per hectare' by 'hectare'

Now I would like to add 'Row Spacing', but
If Row Spacing is 3Feet, then multiply Price per hectare by 1 and by hectare
if Row Spacing is 5Feet, then multiply Price per hectare by .35 and by hectare
if Row Spacing is 7Feet, then multiply Price per hectare by .22 and by hectare

I would be grateful for your help.
Thank you,
Manjula

**TMS** · 10-31-2012, 06:51 AM

Suggest you upload a sample workbook with some typical data ... and the answers you expect to see.

Regards, TMS

**Manjula1** · 10-31-2012, 08:02 AM

thank you.
attached, please find the worksheet.

**TMS** · 10-31-2012, 08:13 AM

=CHOOSE(MATCH($G7,{"","3 Feet","5 Feet","7 Feet"},0),0,1,0.35,0.22)

=IF($F7=0,0,IF($E7="Maize",I$4*$F7,0))*CHOOSE(MATCH($G7,{"","3 Feet","5 Feet","7 Feet"},0),0,1,0.35,0.22)

or you could set up a small data table somewhere and use VLOOKUP

Regards, TMS

**Manjula1** · 11-01-2012, 03:11 AM

Thank you TMS, it worked like a charm.
wonderful!

**TMS** · 11-01-2012, 04:42 AM

You're welcome. Thanks for the rep.

various conditions that have to be met in an if statement

LinkBack

Thread Tools

Rate This Thread

Display

various conditions that have to be met in an if statement

Re: various conditions that have to be met in an if statement

Re: various conditions that have to be met in an if statement

Re: various conditions that have to be met in an if statement

Re: various conditions that have to be met in an if statement

Re: various conditions that have to be met in an if statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions