Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |