Basic formula issue.. Stuck

Brent Blevins · #1 (**permalink**) 10-10-07, 11:08

I have the following formula.

=IF(D10>(C10+20),"B",IF(D10<=C10,"G"))

Basically if the value of Cell D10 is = to C10 + 20, I want to place a "B" in my cell. If D10 is Less Than or Equal To C10 I want a "G" placed in my cell.

When I type the numbers in the cells i get the following results:
If D10 is Greater than C10 the formula does not work and the value in the cell is "FALSE".

If D10 is Less Than or Equal To C10, the formula works

I hope this makes sense, any ideas?

gvee · #2 (**permalink**) 10-10-07, 11:36

Try this

Code:

=If(D10=C10+20, "B", If(D10<=C10, "G", ">C10"))

Internet Services

Web Development

Digital Marketing

Consumer Tech