Formula result different from value shown in cell

W

Wendy Seah

Hi,

I was trying to average across 2 worksheets with 2
different arguments built in. I can see the formula
result in the screen which is the correct answer but what
comes on the cell is totally different. I have tried
hitting "Ctrl+Equal Sign" in the active worksheet but it
did not help.

I am using Excel 2000.

Many thanks in advance for any help :)

Wendy.
 
N

Niek Otten

Hi Wendy,

What do you mean with "in the screen" and "on the cell"? What formula did
you use? What were the values of the input cells? What did you expect as a
result? What did you get instead?
 

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

Drop down list control value in vba 2
Formula Result is different from the shown result 2
formula for arriving net difference 0
formula displays as a formula, not as its result 1
Formula not working properly 2
Hide columns based on row values 2
Excel Formula question 0
formula result is zero but zero is not populating in cell 3

Top