Hi,
I have a formula, which is working correct:, but in this specific cell it is not calculating.Formula:
Please Login or Register to view this content.
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
From 2nd formula, release the text: "0", "1" ... to real number 0,1,... then it should works.
Quang PT
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
Or short cut: plus 0 to convert text into number
Your formula+0
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks