Is there an "IF... Then" option I can use?

Like:
If SUM(H1:H100),2=SUM(A101:G101),2, then input the Sum.
And if SUM(H1:H100),2 does NOT equal SUM(A101:G101),2, then input "ERROR".

(By the way, do I need the ",2"? I'm not sure what that denotes.)

Thanks


"Ken Wright" wrote:

> =ROUND(SUM(H1:H100),2)=ROUND(SUM(A101:G101),2) could be one way. I use
> round in there because for various reasons (floating point accuracy) you
> could have say what looks like 0.2 = 0.2 as a result (and you would expect
> TRUE) which was in reality 0.2=0.19999999999 or something similar and
> returned FALSE.
>
> http://cpearson.com/excel/rounding.htm
>
> Use conditional formatting to flag the cell bright red if the answer is
> FALSE.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Nicole L." <NicoleL@discussions.microsoft.com> wrote in message
> news:11C62BC5-0094-4EB9-81C5-3CC11332F755@microsoft.com...
> > Is there a way to put a formula in a cell to compare the total of the
> cells
> > above it (the column) and the totals of the data in the cells to the left
> of
> > it (the row) to make sure they match up? I would use this just to make
> sure
> > that I hadn't messed up any of my SUMs throughout the worksheet. Just as a
> > doublechecking mechanism.
> >
> > Thanks
>
>
>