Need help with =if(or(and...

[Chris van der Berg]

Hi Everyone,

Attached please find Book1.xlsx.
I want to combine the formula in G6 to I6 into one formula.
Is it possible to do it with if(or(and or is there another way of doing it.

Regards

Chris

 

[Chris van der Berg]

To clarify my request:
1)if there is values in A6 and B6 I want the formula to calculate A6xB8xE6=F6
2)If there is values in A6,B6 and C6 I want the formula to calculate A6xB6xC6xE6=F6 and
3)if there is a value in D6 I want the formula to calculate D6xE6=F6
The fields A6 to D6 will be used in combinations eg. A6 and B6 or A6,B6 and C6, or D6
The formula must not combine the sum total of all three formula's

 

[Debraj]

In the attached.. what will be your expected output.. (Numeric figure..!!!)

 

[json]

For items 1 & 2:
=IF(ISBLANK(C6),A6*B6*E6,A6*B6*C6*E6)

i dont know if i understand part 3... are you saying that if d6 have a value, you just want to use those 2 cells to calculate a result?


this? =IF(NOT(ISBLANK(D6)),E6*D6,IF(ISBLANK(C6),A6*B6*E6,A6*B6*C6*E6))

 

[Chris van der Berg]

Hi Jason,

Perfect!!! Just what I want.

Thanks a lot.

Happy Xmas

Chris

 

[json]

glad to help!!