Formula ?

[natei6]

Hello To All,

=IF(SUM(_X16+_X38 )<17,1,SUM(_X16+_X38 )/15),IF(SUM(_X16,_X38)<1,"")

This formula is returning a #value error. The result I am seeking is
If SUM(_X16+_X38 ) is 0, "" else between 1 and 16, 1 else more than 1
SUM(_X16+_X38 )/15. What am I doing wrong?

Thanks In Advance,

Nathan Sargean

 

[Michael]

Hi Natei6
Try this:

=IF(SUM(X16+X38)=0,"",IF(AND(X16+X38<17,X16+X38>1),1,IF
(X16+X38>16,(X16+X38)/15)))

Regards
Michael

 

[Jerry W. Lewis]

Perhaps

=IF(SUM(_X16,_X38)<1,"",IF(SUM(_X16+_X38 )<17,1,SUM(_X16+_X38 )/15))

Jerry
Excel MVP

 

[natei6]

Hi

Thanks Soooo Much


Nathan Sargean