Windows XP Formula not calculating in correct order - please help

Joined
Jun 18, 2009
Messages
1
Reaction score
0
Here is he formula that I have for a cell in Excel:
=(2*I:I)/(CHINV(0.2,2*IF(E:E>500,500,E:E)))

order of evaluation
I*I
(2*I:I)
CHINV

it does not evaluate the data/formula within the brackets of CHINV but evaluates "CHINV" by itself to #NAME? -- so that the formula now looks like:

=(2*I:I)/(#NAME?( 0.2, 2*IF(E:E>500,500,E:E))) which eventually results in #NAME? in that cell.

How do i correct it?
All ideas, suggestions, solutions welcome.

Thanks
Latika
 

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

Top