why doesn't excel count "numbers" in an IF formula

N

Noddy2011

My formula is =IF(AND(0<J3,J3<6),J3+1,"6") but when i use sum to add the
cells together is doesn't count any cell with "6" in. Why is this and how do
i change this please.
 
M

Mike H

Hi,

The quotes around the 6 make it text so sum won't add them up

=IF(AND(J3>0,J3<6),J3+1,6)

Note I've also changed the formula to a more understandable format.

Mike
 
M

Mike H

Hi,

I don't understand the question. You can't directly change a cell colour
with a formula but you can evaluate the formula result with conditional
formatting and change colour. What colours do you want and in what
circumstances?

Mike
 

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

Nested IF functions 2
How to do COUNTIF when cells are not in a consequtive column? 4
Rounding up with IF 6
forecast a financial value at year end 1
Countifs function equivalent for Excel 2002 (XP) 1
How do I combine a VLOOKUP formula and a NETWORKDAYS formula? 2
Help with "IF" Formula 3
i can't get this formula to work 3

Top