Formula ?

  • Thread starter Thread starter natei6
  • Start date Start date
N

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
 
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
 
Perhaps

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

Jerry
Excel MVP
 
Back
Top