Generating a value using the if/and functions

[aurael]

Sorry about title I am using if/or function

I am using Excel 2007. I currently have the formula
=VLOOKUP(B3,Table1[[Food List]:[calories]],2,0) in cell G3.

I also have drop down boxes in D3,E3 & F3 which are titled amount, grams & millilitres respectively.

I want to add to the G3 formula so that when I select a value from either G3,E3 or F3 from their drop down box, the value already in G3 multiplies by the value selected

I have already attempted this without luck by using the following formula addition

=VLOOKUP(B3,Table1[[Food List]:[calories]],2,0)IF(OR(D3>0,E3>0,F3>0),*G3,"")

I am under the impression that if either D3,E3 or F3 are greater than 0 then the value will be multiplied by the value in G3 or left blank

 

[Aladin Akyurek]

Sorry about title I am using if/or function

I am using Excel 2007. I currently have the formula
=VLOOKUP(B3,Table1[[Food List]:[calories]],2,0) in cell G3.

I also have drop down boxes in D3,E3 & F3 which are titled amount, grams & millilitres respectively.

I want to add to the G3 formula so that when I select a value from either G3,E3 or F3 from their drop down box, the value already in G3 multiplies by the value selected

I have already attempted this without luck by using the following formula addition

=VLOOKUP(B3,Table1[[Food List]:[calories]],2,0)IF(OR(D3>0,E3>0,F3>0),*G3,"")

I am under the impression that if either D3,E3 or F3 are greater than 0 then the value will be multiplied by the value in G3 or left blank

=VLOOKUP(B3,Table1[[Food List]:[calories]],2,0)*MAX(D3:F3)

If so desired, custom format the formula cell as:

[=0]"";General

 

[aurael]

Aladin,
Thankyou for your assitance, that worked great!

I didn't quite understand.... "If so desired, custom format the formula cell as:

[=0]"";General"

 

[Aladin Akyurek]

Aladin,
Thankyou for your assitance, that worked great!

You are welcome.

I didn't quite understand.... "If so desired, custom format the formula cell as:

[=0]"";General"

If you want to, you can display a blank when a cell value is 0 using the custom format I suggested.