B blb New Member Apr 19, 2024 #1 Sirs, Can Someone help with conditional formula? Details in attachment Attachments Sample Data.xlsx 213.9 KB · Views: 4
AliGW Well-Known Member Apr 19, 2024 #2 In E2: Code: =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]]))
In E2: Code: =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]]))
B blb New Member Apr 19, 2024 #3 Thanks. Can you pls put this formula in worksheet? There are other conditions to fulfill
V vletm Excel Ninja Apr 19, 2024 #6 blbAre You details correct & verified? Check this ... Attachments Sample Data.xlsx 215.4 KB · Views: 3