Using the IF Command

  • Thread starter Thread starter Eugene
  • Start date Start date
E

Eugene

How do I set up my worksheet to use the IF Command.

I have Columns C D E G in a Row

C can only have a value of 1 to 5. If this value is filled in D & E must be
blank and G should be 5

D can only have a value of 0. If filled in C & E must be blank and G should
be 5

If C & D is blank E should have NA and G should be 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Formula than understands midnight? 25
Bugs in vlookup? 0
Match a group of cells with another group of cells 1
Excel Countifs/Sumproduct with mutil Or statement 3
Function indicating a row have empty value on several columns 2
Any way to test whether rows are empty or contain the word Pass ? 1
SUMIF to sum multiple columns of data? 2

Back
Top