| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
You want to extend the formula how? Down the column AN? Looking at the formula as you've entered it, it appears you can copy that down as is and it will function in each row the same way. Just highlight the cell, grab the little box in the lower right corner and drag it down as far as you want. Is this what you meant by "extend"? -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48996 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
sorry maybe i couldn't explained well, actuall what i wanted, if AK8 cell is
empty then need W8 cell value... =SUM(W8+AK8) ----------------------------------------------------------------------------------- "JBeaucaire" wrote: You want to extend the formula how? Down the column AN? Looking at the formula as you've entered it, it appears you can copy that down as is and it will function in each row the same way. Just highlight the cell, grab the little box in the lower right corner and drag it down as far as you want. Is this what you meant by "extend"? -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48996 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
Could you please explain to us in what way you expect =SUM(W8+AK8) to differ
from =W8+AK8 ? -- David Biddulph Tufail wrote: sorry maybe i couldn't explained well, actuall what i wanted, if AK8 cell is empty then need W8 cell value... =SUM(W8+AK8) ----------------------------------------------------------------------------------- "JBeaucaire" wrote: You want to extend the formula how? Down the column AN? Looking at the formula as you've entered it, it appears you can copy that down as is and it will function in each row the same way. Just highlight the cell, grab the little box in the lower right corner and drag it down as far as you want. Is this what you meant by "extend"? -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48996 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
"Tufail" wrote:
=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 --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
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 : ----------------------------------------------------------------------------------------------- "Max" wrote: "Tufail" wrote: =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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
