hi
I have a large worksheet which uses the formula to extract an amount if certain condition is met. the formula is if($b$1>=f1,c2,0). similar formula is copied to d2 to k2.is there a any replacement for the if function to get the same result
Tks
Shamsu
I have a large worksheet which uses the formula to extract an amount if certain condition is met. the formula is if($b$1>=f1,c2,0). similar formula is copied to d2 to k2.is there a any replacement for the if function to get the same result
Tks
Shamsu