I am using this formula in E5:E65 Column
=IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J 5*1.5+K5*1.8+L5*2))
In D5:D65 I have numbers from 0-20 & this is what i need as well
If there is a value in D Column i need it instead of SUM
it looks something like this but its not working for me

=IF(B6="","",IF(D50,D5,D5=0,SUM(AB5+F5*1.5+G5*1.5 +H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))
What am i doing wrong

maybe something this:

=IF(D50,D5,IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1 .5+I5*1.5+J5*1.5+K5*1.8+L5*2)))

--


Gary Keramidas
Excel 2003


"Mike" wrote in message
...
I am using this formula in E5:E65 Column
=IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J 5*1.5+K5*1.8+L5*2))
In D5:D65 I have numbers from 0-20 & this is what i need as well
If there is a value in D Column i need it instead of SUM
it looks something like this but its not working for me

=IF(B6="","",IF(D50,D5,D5=0,SUM(AB5+F5*1.5+G5*1.5 +H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))
What am i doing wrong

You don't seem to have told the SUM function what you want it to add to
(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5* 2) [and nor did the OP, of
course.]

Perhaps you intended to say
=IF(D50,D5,IF(B6="","",AB5+F5*1.5+G5*1.5+H5*1.5+I 5*1.5+J5*1.5+K5*1.8+L5*2))
--
David Biddulph

Gary Keramidas wrote:
maybe something this:

=IF(D50,D5,IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1 .5+I5*1.5+J5*1.5+K5*1.8+L5*2)))


"Mike" wrote in message
...
I am using this formula in E5:E65 Column
=IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J 5*1.5+K5*1.8+L5*2))
In D5:D65 I have numbers from 0-20 & this is what i need as well
If there is a value in D Column i need it instead of SUM
it looks something like this but its not working for me

=IF(B6="","",IF(D50,D5,D5=0,SUM(AB5+F5*1.5+G5*1.5 +H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))
What am i doing wrong

nope, just following the op's convention. i thought about shortening it, but
didn't. this is what i was going to post and then decided to just follow the
op's convention.

=IF(D50,D5,IF(B6="","",AB5+SUM(F5:J5)*1.5+K5*1.8+ L5*2))

--


Gary Keramidas
Excel 2003


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You don't seem to have told the SUM function what you want it to add to
(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5* 2) [and nor did the OP, of
course.]

Perhaps you intended to say
=IF(D50,D5,IF(B6="","",AB5+F5*1.5+G5*1.5+H5*1.5+I 5*1.5+J5*1.5+K5*1.8+L5*2))
--
David Biddulph

Gary Keramidas wrote:
maybe something this:

=IF(D50,D5,IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1 .5+I5*1.5+J5*1.5+K5*1.8+L5*2)))


"Mike" wrote in message
...
I am using this formula in E5:E65 Column
=IF(B6="","",SUM(AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J 5*1.5+K5*1.8+L5*2))
In D5:D65 I have numbers from 0-20 & this is what i need as well
If there is a value in D Column i need it instead of SUM
it looks something like this but its not working for me

=IF(B6="","",IF(D50,D5,D5=0,SUM(AB5+F5*1.5+G5*1.5 +H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))
What am i doing wrong