pao13
Member
Hi.
I attach my workbook. I would like a formula so that cells in column G to have a maximum value of $V5/E4*100 (for G4). Otherwise to keep their values. This is the formula now in column G: IF(MOD(ROW(),2)=0,(ROUND($V$4/E4/100*(1+IF(K3<0,Y4*10%,0)),0)),G3)
Thanks as always
I attach my workbook. I would like a formula so that cells in column G to have a maximum value of $V5/E4*100 (for G4). Otherwise to keep their values. This is the formula now in column G: IF(MOD(ROW(),2)=0,(ROUND($V$4/E4/100*(1+IF(K3<0,Y4*10%,0)),0)),G3)
Thanks as always