Formula Question

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

natei6

Hi to all,

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

This formula is working unless SUM(_X16+_X38) is 0. How do I amend i
to make the result 0 instead of 1?

All The Best

Nathan Sargean
 
if you are trying to say that if x16+x38 is less than 17,1, else that /15,
try
=if(x16+x38)<17,1,(x16+x38)/15
or
if(sum(x16,x38)<17, etc
 
Hi, Don

I believe that is the formula I'm already using, what I need is a
amendment to make the result zero if Sum(X16,X38) equals zero.

Any help appreciate,

Nathan Sargeant
 
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
 
Nathan,

Your formula returned #NAME? until I removed the underscores (XL97) then it
returned #VALUE!

try:
=IF(X16+X38<1,"",IF(X16+X38<17,1,(X16+X38)/15))

I believe that the reason for the #VALUE! error is that the IF statement is
complete after the bracet following 15

Note that, (in your formula), if a value is <1, it will also pass the <17
test so even if the syntax was right it would never get to the <1 test

HTH

Dandy
 
Back
Top