Data Validation with optional user input

CHIPS4CAM

New Member
Joined
Nov 17, 2005
Messages
2
I am trying to create a formula which will return "N/A" if a condition is true, and allow the user to input one of 2 variables if a condition is false (ie: if cell A6 is $0.00, then cell B6 should automatically be "N/A", but if A6 > $0, then I want the user to enter a variable of either "B" or "O" to show who the $ were paid to). I am stuck!

Thanks,
Cam
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
Do you want the user to enter the B or O in the same cell where you are displaying the N/A?

If so, you could do something like this in B6:
=IF(A6=0,"N/A","ENTER B OR O")

This will indicated the cells that are to be updated by the user vs the ones that are N/A.

HTH
 

CHIPS4CAM

New Member
Joined
Nov 17, 2005
Messages
2
Thanks, but what I am really trying to do is to limit the possible entries to "N/A", "B', or "O" with the formula for B6 of (=IF(A6=0,"N/A".........but then if it is not, I want the user to enter either "O" or "B" without the "O" or "B" erasing the formula in case the user has to change A6 later. I have placed the instructions to the user under the DATA VALIDATION section so it tells the user what to enter, but I am trying to make the N/A automatic. Maybe my user enter is not compatible with the N/A formula.

Cam
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,128
Messages
5,857,533
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top