Formula

[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...

 

[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"

 

[Max]

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

Maybe you meant this
In AN8: =IF($AK8="",$W8,SUM($W8,AK8))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[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)

 

[David Biddulph]

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

 

[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 : (e-mail address removed)

-----------------------------------------------------------------------------------------------