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
=(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