Help !!!

M

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 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(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
 
G

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

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

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


David Biddulph said:
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

Gary said:
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)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top