concatenating a formula with a statement

  • Thread starter Thread starter Iatollah
  • Start date Start date
I

Iatollah

Hi everyone,

I'm trying to do a simple IF statement that tells me if something
doesn't balance but I want the directive to tell me how much it is out
by. Here's what I have:

=IF(SUM(F7:H7)<>I7,"ERROR - Does Not Balance","")

Instead of the result being "ERROR - Does Not Balance" I want to make
the result "ERROR - Does Not Balance. Out by x" with x being the
difference in the the values of the 2 cells referenced in the first
part of the IF statement.

Any suggestions would be greatly received.

Thanks heaps,

Iatollah ;)
 
I think you want this:
=IF(SUM(F7:H7)<>I7,"ERROR - Does Not Balance. Out by " & i7-sum(f7:h7) & ".","")
 
Back
Top