Help !!!

[Mike]

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+J5*1.5+K5*1.8+L5*2))
In D565 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(D5>0,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

 

[Gary Keramidas]

maybe something this:

=IF(D5>0,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)))

 

[David Biddulph]

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(D5>0,D5,IF(B6="","",AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))

 

[Gary Keramidas]

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(D5>0,D5,IF(B6="","",AB5+SUM(F5:J5)*1.5+K5*1.8+L5*2))

--


Gary Keramidas
Excel 2003

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(D5>0,D5,IF(B6="","",AB5+F5*1.5+G5*1.5+H5*1.5+I5*1.5+J5*1.5+K5*1.8+L5*2))
--
David Biddulph

maybe something this:

=IF(D5>0,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)))