Conditional Statement in Excel

  • Thread starter Thread starter Wendy.Craigg
  • Start date Start date
W

Wendy.Craigg

Hi,

I'm trying to create an if statement that whenever the user selects
"Debit Memo" from the dropdown menu in column A (has other items--
Credit Memo Check, Transfer), the user would be forced to enter the
corresponding value in column F (Debit). If the user attempts to
enter the value in Column G (Credit)column, an error message would be
generated "Incorrect Account".

Grateful for any assistance in resolving this matter.


WC
 
One way:

Select your cells in Column G (say, G2:G100, with G2 the active cell).
Choose Data/Validation, and enter

Allow: Custom
Formula: =$B2="Credit Memo"

Uncheck the Ignore Blanks checkbox. Similarly, in column F, use

=$B2="Debit Memo"

If more than one value in column B is acceptable for a column G entry,
use OR(), e.g.:

=OR($B2="Credit Memo",$B2="Transfer")
 
Back
Top