| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Problem
Have at it guys.
Im putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,A,IF(A113<18,RESULT,IF(A1 =18,B))) Danny |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
See your earlier two threads. Don't start a new thread when your question
has already been answered. -- David Biddulph "Danny" wrote in message ... Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B","")))
"Danny" wrote: Have at it guys. Im putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,A,IF(A113<18,RESULT,IF(A1 =18,B))) Danny |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
I'm intrigued by your second test, John. You are comparing A1<18 with 13.
A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence A1<1813 is always TRUE, so your test isn't doing anything useful. You may wish to reconsider your advice to Danny? [Or you may wish to let Danny take the advice which he was given in an earlier thread where he asked the same question.] -- David Biddulph "John Moore" wrote in message ... Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
Hi David,
Thanks for the correction. However, this is a different question than my first post. Danny "David Biddulph" wrote: See your earlier two threads. Don't start a new thread when your question has already been answered. -- David Biddulph "Danny" wrote in message ... Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
Thank you John. I'll give it a try.
Danny "John Moore" wrote: Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. Im putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,A,IF(A113<18,RESULT,IF(A1 =18,B))) Danny |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
David,
Instead of criticizing John and me, it would have been good to put that energy ito a solution to the problem. Have a nice day. Danny "David Biddulph" wrote: I'm intrigued by your second test, John. You are comparing A1<18 with 13. A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence A1<1813 is always TRUE, so your test isn't doing anything useful. You may wish to reconsider your advice to Danny? [Or you may wish to let Danny take the advice which he was given in an earlier thread where he asked the same question.] -- David Biddulph "John Moore" wrote in message ... Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
Two different answers to your syntax error were given by Dave Peterson and
by Max in response to your original question in the thread "Excel ranges within a cell". -- David Biddulph "Danny" wrote in message ... David, Instead of criticizing John and me, it would have been good to put that energy ito a solution to the problem. Have a nice day. Danny "David Biddulph" wrote: I'm intrigued by your second test, John. You are comparing A1<18 with 13. A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence A1<1813 is always TRUE, so your test isn't doing anything useful. You may wish to reconsider your advice to Danny? [Or you may wish to let Danny take the advice which he was given in an earlier thread where he asked the same question.] -- David Biddulph "John Moore" wrote in message ... Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
thanks, Johan, I'll give it a try. Will let you know.
Danny "John Moore" wrote: Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. Im putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,A,IF(A113<18,RESULT,IF(A1 =18,B))) Danny |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
thank you David. I will look that up. Didn't realize I had entered the same
question under a different subject heading. Danny "David Biddulph" wrote: Two different answers to your syntax error were given by Dave Peterson and by Max in response to your original question in the thread "Excel ranges within a cell". -- David Biddulph "Danny" wrote in message ... David, Instead of criticizing John and me, it would have been good to put that energy ito a solution to the problem. Have a nice day. Danny "David Biddulph" wrote: I'm intrigued by your second test, John. You are comparing A1<18 with 13. A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence A1<1813 is always TRUE, so your test isn't doing anything useful. You may wish to reconsider your advice to Danny? [Or you may wish to let Danny take the advice which he was given in an earlier thread where he asked the same question.] -- David Biddulph "John Moore" wrote in message ... Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. I'm putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,"A",IF(A113<18,"RESULT",IF(A1=18,"B") )) Danny |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Problem
Hi John,
That formula worked well for the parameters that I set out. Thank you very much. As you know solving one problem can sometimes create others. What I would also like the formula to be able to do is if there is no value entered into cell A1, then nothing shows in cell A2. As the formula stands now, when no value is entered in A1, "A" is printed in A2. Danny "Danny" wrote: thanks, Johan, I'll give it a try. Will let you know. Danny "John Moore" wrote: Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B",""))) "Danny" wrote: Have at it guys. Im putting formula into A2. I want it to return a value for this formula, but I think the syntax is wrong. Help greatly appreciated. =IF(A1<=13,A,IF(A113<18,RESULT,IF(A1 =18,B))) Danny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
![Danny[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
