B Brooke Aug 20, 2003 #1 I need to write a IF formula that will show the sum of the selected cells if that sum is not 1.
J Jim Blackburn Aug 20, 2003 #2 Try =IF(SUM(range) said: -----Original Message----- I need to write a IF formula that will show the sum of the selected cells if that sum is not 1. . Click to expand...
Try =IF(SUM(range) said: -----Original Message----- I need to write a IF formula that will show the sum of the selected cells if that sum is not 1. . Click to expand...
L Lance Aug 20, 2003 #3 =IF(SUM(A1:A5) said: -----Original Message----- I need to write a IF formula that will show the sum of the selected cells if that sum is not 1. . Click to expand...
=IF(SUM(A1:A5) said: -----Original Message----- I need to write a IF formula that will show the sum of the selected cells if that sum is not 1. . Click to expand...
B Brooke Aug 20, 2003 #4 YOU ROCK!!! Thanks, it works perfectly!! Brooke -----Original Message----- Brooke, Try this amended version =IF(SUM($D$98,$D$92,$D$86,$D$80,$D$74,$D$68)=1,"weighting ok","weighting equals " & SUM($D$98,$D$92,$D$86,$D$80,$D$74,$D$68) & " make changes to the available weights.") -- HTH Bob Phillips . Click to expand...
YOU ROCK!!! Thanks, it works perfectly!! Brooke -----Original Message----- Brooke, Try this amended version =IF(SUM($D$98,$D$92,$D$86,$D$80,$D$74,$D$68)=1,"weighting ok","weighting equals " & SUM($D$98,$D$92,$D$86,$D$80,$D$74,$D$68) & " make changes to the available weights.") -- HTH Bob Phillips . Click to expand...
