Hello All
I am using excel 2007,the number 10 is entered in cell A1,formula in B1 is =IF(AI<20,"yes").
Getting formula contains an error message,<20,"yes" highlighted.Simple formulas ie 10+20 and SUM function calculate ok.SUMIF and COUNTIF wont calculate.
I have tried to change the format to general and number to no avail,I dont think its a format problem as its slill
able to calculate simple formulas.Many thanks for help given.
Last edited by bigband1; 03-28-2014 at 09:25 AM.
You have actually typed AI in that formula rather than A1 - is that what is causing the problem?
Pete
Your formula refers to AI not A1.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Sorry typing error the formula is in A1
is it possible it has a space in it or is formatted as text? what happens if you point =isnumber(a1) at it?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
What is error message? Also what should formula return if criteria not met? (I hope is another typo that you say formula is in A1 - this would be circular reference)
In A1 i have 10,In B1 i have the formula =IF(A1<20,"YES"),I have tried this on another comp,it calcs ok.
If i enter the formula =ISNUMBER(A1) in B1 i get TRUE.The error message is The formula you typed contains an error.Could it be a bug.
You may have to either post it as is or a representative sample to get more help so people can see what is happening. If you use the same info and formula elsewhere do you get the same result? Usually you need the "else what to do" in an if statement and you don't have that though it should still work. you know, =IF(A1<20,"YES", but if not then what?)
Please find attached worksheet,I have omitted the = sign to enable attachment.
Last edited by bigband1; 03-24-2014 at 12:10 PM.
It works okay for me. I just put the = sign in front of the formula and it gave me yes. If I change A1 to 25 I get FALSE, as expected.
Pete
Agree w/Pete, needs = in front of the equation then it will work.
Got it
Somehow the comma in formulas changed to a pipe,maybe through an imported formula.Changed it back to a comma in regional settings,list separator.Found the answer in excel forum question "Formulas require pipe instead of comma" 03/18/11.Thanks all for your answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks