Formula

T

Tufail

hi,
i am using below formula and now want bit extend.

=IF($AK8="","",SUM($W8+AK8))
if AK8 is empaty then bring $W8 value....
Formula cell is in AN8....

thanks in advance...
 
J

JBeaucaire

You want to extend the formula how? Down the column AN

Looking at the formula as you've entered it, it appears you can cop
that down as is and it will function in each row the same way. Jus
highlight the cell, grab the little box in the lower right corner an
drag it down as far as you want

Is this what you meant by "extend"
 
T

Tufail

sorry maybe i couldn't explained well, actuall what i wanted, if AK8 cell is
empty then need W8 cell value...

=SUM(W8+AK8)
 
D

David Biddulph

Could you please explain to us in what way you expect =SUM(W8+AK8) to differ
from =W8+AK8 ?
 
T

Tufail

Yes...perfect.....Max i am leving in Japan and want to be your student....may
i have your adress of Singapore ? next week i am coming there....if you don't
mind...my mail is : [email protected]

-----------------------------------------------------------------------------------------------
 
Top