Conditional Formula

[blb]

Sirs,
Can Someone help with conditional formula?
Details in attachment

 

[AliGW]

In E2:

=IF(AND([Life Type]="Consumption Per Tundish",[UOM]="NOS"),[@[Act Cons]]/[@[No of Tun]],
IF(AND([Life Type]="Cons Per Tundish",[UOM]="KGS"),[@[Act Cons]]/[@[No of Tun]],
[@[Act Cons]]*[@[No of Tun]]))

 

[blb]

Thanks. Can you pls put this formula in worksheet?
There are other conditions to fulfill

 

[AliGW]

Why? Just copy and paste it into E2. Don't be so lazy!!!

 

[blb]

Ok. Thanks.
Faced some issue earlier, Anyway this is resolved

 

[vletm]

blb​

Are You details correct & verified?
Check this ...