Subscribe to AfterDawn's weekly newsletter.
Excel Help
#1
04 Aug 2010 @ 11:25
emdadhul
Send private message to this user
Junior Member
Hi I need help with Excel.
Basically what I want to do is use an IF statement or otherwise to set up excel to allow only one value to be inserted into one of two collums not both. If values are typed into both fields excel shouldn't accept it and give an error message.
Please can someone help me with the Excel Jargon
Many Thanks
Basically what I want to do is use an IF statement or otherwise to set up excel to allow only one value to be inserted into one of two collums not both. If values are typed into both fields excel shouldn't accept it and give an error message.
Please can someone help me with the Excel Jargon
Many Thanks
AfterDawn
Advertisement
#2
04 Aug 2010 @ 13:31
You need to use validation rules for that, based on an IF statement.
In both of your fields, set a validation rule as follows:
That is the validation rule that would go in cell A2, and vice versa for cell B2. You can set a custom error message in the other tabs.
IF(B2="*",0,0)
IF( - function
B2="*" - B2 equals anything
,0,0) - display nothing (you can change these values to display things within the cell. the first value is what would be displayed if B2 was empty, and the second value is what would be displayed if B2 contained a value)
Hope that helps.
Edit: Based on the above, it would return this..
In both of your fields, set a validation rule as follows:
That is the validation rule that would go in cell A2, and vice versa for cell B2. You can set a custom error message in the other tabs.
IF(B2="*",0,0)
IF( - function
B2="*" - B2 equals anything
,0,0) - display nothing (you can change these values to display things within the cell. the first value is what would be displayed if B2 was empty, and the second value is what would be displayed if B2 contained a value)
Hope that helps.
Edit: Based on the above, it would return this..
This message has been edited since its posting. Latest edit was made on 04 Aug 2010 @ 13:34
#4
04 Aug 2010 @ 14:24
emdadhul
Junior Member
Would I be able to ask you for a favour, can you kindly make me a screen capture video of the above
#5
05 Aug 2010 @ 5:29
I don't have any video capture software installed anymore, but if you want I'll make you a spreadsheet with the validation rules set and you can have a look for yourself.
#7
05 Aug 2010 @ 7:03
What I had in mind didn't work in practise, I'll mess around with it some more (I'm not an Excel expert by any means, far from it). You may have to use Visual Basic to achieve your result, in which case I wouldn't be able to help you - Googling it provides quite a few answers. Sorry :-(
#8
05 Aug 2010 @ 7:21
emdadhul
Junior Member
Originally posted by Ripper:I've never heard of Visual Basic lol......Thanks 4 trying please do let me know if you have any joy with EXCEL.
What I had in mind didn't work in practise, I'll mess around with it some more (I'm not an Excel expert by any means, far from it). You may have to use Visual Basic to achieve your result, in which case I wouldn't be able to help you - Googling it provides quite a few answers. Sorry :-(
Many Thanks
#9
05 Aug 2010 @ 7:54
Visual Basic is a type of code that you can use within Excel to perform more advanced functions. You'd be better off posting on a specialised help forum I think, perhaps this one:
http://www.excelforum.com/
Unless someone who is good with VB happens upon this thread!
http://www.excelforum.com/
Unless someone who is good with VB happens upon this thread!
#10
05 Aug 2010 @ 8:02
emdadhul
Junior Member
Originally posted by Ripper:Thanks will try!!!!
Visual Basic is a type of code that you can use within Excel to perform more advanced functions. You'd be better off posting on a specialised help forum I think, perhaps this one:
http://www.excelforum.com/
Unless someone who is good with VB happens upon this thread!
This discussion thread has been automatically closed, as it hasn't received any new posts during the last 180 days. This means that you can't post replies or new questions to this discussion thread.
If you have something to add to this topic, use this page to post your question or comments to a new discussion thread.
If you have something to add to this topic, use this page to post your question or comments to a new discussion thread.
