You're missing a condition...

What if Goal is equal to Actual?

Goal = 100
Actual = 100

What happens in that case?


--
Biff
Microsoft Excel MVP


"davidgrandma" wrote in message
...
I just read your response to a formula question and you seem pretty
knowledgeable. I have 3 columns: Goal, Actual and Base. I am trying to
find
a formula that will compare the amounts in both columns and post the
correct
amount in Base.
If the amount in actual is more than the amount in goal then base = goal,
but if actual is less than goal, then the base is actual.

I can't quite get the formula for this. Do you have any clues for me?

Thanks

Donna


"Don Guillett" wrote:

Funny, I just tested with a sheet named week1 and a sheet named week5.
Perhaps you have spaces or a leading or trailing space?

--
Don Guillett
SalesAid Software

"amartin-kelly" wrote in message
...
hi
thank you for your information but when i do that (which is makes total
sense now that i think about it) ..i write the formula as
=sum(week1:week5!a8)
because we named the pages "week"
after i finish the formula it says something like #NAME!*? and tells me
that
the name for "week1" is unrecongnizable.
any thoughts
thanks

"Don Guillett" wrote:

if all in the same cell
=sum(page1:pag5!a1)

--
Don Guillett
SalesAid Software

"amartin-kelly" wrote in
message
...
How would I set up a formula that consists of a sum on page 1 + a
sum
on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5?