# 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

2. ## Re: Correct Formula not calculating

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

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

4. ## Re: Correct Formula not calculating

Or short cut: plus 0 to convert text into number
Your formula+0

5. ## Re: Correct Formula not calculating

Thank you so much

#### Thread Information

##### Users Browsing this Thread

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1