"IF" COMMAND

  • Thread starter Thread starter D10
  • Start date Start date
D

D10

I'M TRYING TO GET MY SPREADSHEET TO WORK PROPOERLY WITH
THE RIGHT COMMAND, BUT FOR SOME REASON IT'S NOT
WORKING..PLEASE HELP!!
OK..SO I HAVE A COLUMN WHICH I'M INPUTTING AN "IF"
COMMAND..SAYING IF(C2>0,"BLK",IF(D2>0,"TRU",IF
(E2>0,"SBT","TUN")))
WELL, IT WORKS FOR THE FIRST THREE ROWS - THEN NO MATTER
WHAT IS IN EACH COLUMN...IT PUTS "BLK"...EVEN IF THERE IS
A QUANTITY IN E2...WHERE IT SHOULD THEN SAY "SBT"
ANYONE HAVE ANY IDEAS WHY IT WOULD WORK FOR THE FIRST 3
ROWS AND THEN IT JUST PUTS "BLK" NO MATTER WHAT?
ALSO, DOES ANYONE KNOW A WAY AROUND THE (7) LIMIT ON
THE "IF" COMMAND??
THANKS FOR YOUR HELP GUYS!!
 
First - please don't post in ALL CAPS - it's considered the equivalent
of shouting, and is difficult to read.

Check your quantities in Cx:Ex to make sure they are actually values,
rather than Text. The C2>0 comparison will always be true if C2 is text.

You can check with:

=ISTEXT(C5)

which will be true for text.

If the values are text, copy an empty cell, select the values and choose
Edit/Paste Special, selecting the Value and Add radio buttons to coerce
the text back to numbers.

For getting around the 7-deep nesting limit, the best method is usually
to use either a lookup table or a mathematical formula, or else use VBA.

But also see

http://cpearson.com/excel/nested.htm
 
Back
Top