# Correct Formula not calculating

1. ## Correct Formula not calculating

Hi,

I have a formula, which is working correct:
Formula:  `Please Login or Register  to view this content.`
, but in this specific cell it is not calculating.

Can this be becuase it is taking an answer from also a formulated cell:
Formula:  `Please Login or Register  to view this content.`
?

Sample worksheet attached  Register To Reply

2. ## Re: Correct Formula not calculating

From 2nd formula, release the text: "0", "1" ... to real number 0,1,... then it should works.  Register To Reply

3. ## Re: Correct Formula not calculating

The answer is simple. If you put " around numbers they are text. Hence the second formula does not work, unless the value in column P is a number

=IF(N9=0;0;IF(N9=1;250;IF(N9=2;500;IF(N9=3;1250;IF(N9=4;2500)))))

might cause it to work as you wish  Register To Reply

4. ## Re: Correct Formula not calculating

Or short cut: plus 0 to convert text into number  Register To Reply

5. ## Re: Correct Formula not calculating

Thank you so much  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 