Create Error Message for Not allowing 2 cells to both have entries

[emdad16]

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

[NBVC]

Use data validation on each cell.

So say you are using A1 and B1

Go to B1, then to Data|Validation.. and choose Custom from Allow menu.

Enter formula: =B1=""

You can go to Error Alert tab to customize the error message if you want.

Click Ok.

Then go to B1 and repeat above with formula: =A1=""

[emdad16]

Hi

It's working Thanks.

One more question, I wan't to make the cell that I am using the Validation rule on to only accept Positive Numbers. How do I do this?

Thanks

[NBVC]

Change formula in A1 to:

=AND(B1="",A1>0)

and check the box that says "Ignore blank"

and do the same in B1 with formula:

=AND(A1="",B1>0)

[Whizbang]

***Edit***

I didn't refresh my screen before submitting respone. NBVC beat me to the answer.

[emdad16]

Hi,

Thanks 4 getting back to me quickly, really apprieciate it. However, I have tried the formula and it's not working

[NBVC]

Did you uncheck the "ignore blanks" box?

I probably mislead you on that above...

[emdad16]

Wow, Thanks M8....I didn't know a simple mistake can muck up the whole formula lol.

Thanks Bro...Thankzzzzzzzzz :-)

[emdad16]

Hi All,

I need help with Excel again, basically what I want to do is as follows. I have a list of names that need to be automatically assigned by excel to a currency.

i.e When ASDA is typed in, in the next collum labelled Currency it should automatically display USD.

Another Example Vodafone......GBP

Santander......EUR

etc.

[NBVC]

Please post new questions in new threads.

Thank You