Hello everyone i need help please!
I have the following formula : =IF($D9=0,"",($D9*INDEX(sheet1!E:G,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))+($E9-$D9)*INDEX(sheet1!H:J,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))
What i am trying is to find an evaluate vba way.. so that my functions returns values .
In other words formula be looking like this: IF($D9=0,"",(210*2.0089)+(210-211)*0.123
i ve been trying hard but i ve had no success
Thank you in advance
I have the following formula : =IF($D9=0,"",($D9*INDEX(sheet1!E:G,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))+($E9-$D9)*INDEX(sheet1!H:J,MATCH($A$18,sheet1!A:A,0),MATCH("X",$N9:$P9,0)))
What i am trying is to find an evaluate vba way.. so that my functions returns values .
In other words formula be looking like this: IF($D9=0,"",(210*2.0089)+(210-211)*0.123
i ve been trying hard but i ve had no success
Thank you in advance