IF Function- ASAP Please! Thnx

B

Brooke

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

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...
 
B

Brooke

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Formatting question: how to format duration (time spent)? 0
Multiple IF Statement in Word 5
filter column unique for alphanumeric 6
Excel - Wich Function should I use? 1
Using SUM(INDIRECT()) 2
Sum above columns until non-numeric encountered 1

Top