If using OR formula help

[orsm6]

Hi,

I am trying to use an IF formula (which works as it is now) but i also want to do the same calculation if another cell is populated. here is the formula so far:

=IF(E36="ON",(E29*0.9)*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)

how can i expand on the above formula to look at D33 also and if there is a value do this

(E36="ON",(D33*0.9)*'SetMix Calc'!$L$60,D33*'SetMix Calc'!$L$60)

thanks

 

[Michael M]

What value in D33 ?
and do the same thing as in E36 ??

 

[orsm6]

the value will be a random number

yes... it will look to see if e36 is on and do same equation but to the value in cell d33

the cell that holds the formula is D52

What value in D33 ?
and do the same thing as in E36 ??

 

[Michael M]

Maybe this
Where D33 AND E36 must have values

=IF(AND(D33<>"",E36="ON"),E29*0.9*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)

 

[orsm6]

Thanks for your help Michael.... this is almost what i am looking for

i don't know how to explain it, i need to somehow combine the following formulas into one IF formula

if E29 is this ... then do that .. but if D33 is this then do that..

=IF(E36="ON",(E29*0.9)*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)
=IF(E36="ON",(D33*0.9)*'SetMix Calc'!$L$60,D33*'SetMix Calc'!$L$60)

Maybe this
Where D33 AND E36 must have values

=IF(AND(D33<>"",E36="ON"),E29*0.9*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)

 

[Michael M]

Jusr write the 2 formulas you require SEPERATELY...and we'll combine them for you

 

[KolGuyXcel]

Maybe (assuming if D33 has some value, the result would ignore E29)

=IF(AND(D33<>"",E36="ON"),(D33*0.9)*'SetMix Calc'!$L$60,IF(D33<>"",D33*'SetMix Calc'!$L$60,IF(E36="ON",(E29*0.9)*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)))

 

[orsm6]

thank you very much, this does exactly what i need it to do.

Maybe (assuming if D33 has some value, the result would ignore E29)

=IF(AND(D33<>"",E36="ON"),(D33*0.9)*'SetMix Calc'!$L$60,IF(D33<>"",D33*'SetMix Calc'!$L$60,IF(E36="ON",(E29*0.9)*'SetMix Calc'!$L$60,E29*'SetMix Calc'!$L$60)))