If Statement Not Working
Oh, crud. I found the error. When I checked for rounding errors, I didn't
go to the max of 30, I just went to 10 and found nothing. Now that I went
back and went to 30, I found the discrepency in the 28th decimal
place.....not sure why that is there.
I'm feeling pretty sheepish right now......
THANK YOU THANK YOU..... I was going to have to go to a mental institution
if I didn't figure this out.
"David Biddulph" wrote:
Do you have rounding errors in your calculations?
What do you get from the formula =SUM(I14:I19)=(G20-H20) ?
What do you get from the formula =SUM(I14:I19)-(G20-H20) ?
What are the contents of I14:I19, G20, and H20, respectively?
--
David Biddulph
"Telegirl" wrote in message
...
Several people have worked on this and I am sure it is something obvious,
but
the following If Statement will not work:
=IF(SUM(I14:I19)=(G20-H20),(G20-H20),"error")
It always returns 'error', even if the statement is true. Any
suggestions?
Thanks a lot!
|