Formula HELP!
 

Would some please help me with this formula? I want the formula to reference
cell J5 - This is what I need: If cell J5 is 6.45 and <9.44, place a number
1 in cell L5 and turn cell L5 yellow.

How can this be done? Thank you

Hello Karen,

This is what you need to put into cell L5,

=SUM(IF(J56.45,IF(J5<9.44,1,0),0))

You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get
{}, these brackets surrounding the equation if you did it right.

Second highlight the L cells you are working with go to TAB PATTERS and
choose your color, then click ok and ok again, whever that specific cell in
the L colomn see the number one it will make it yellow.

Dan
Format - Conditional Formatting

In the first box choose option "Cell Value Is"

In the second box choose option "Equal To"

In the third box type in the number 1

Then click FORMAT at the bottom go to

"Karen" wrote:

Would some please help me with this formula? I want the formula to reference
cell J5 - This is what I need: If cell J5 is 6.45 and <9.44, place a number
1 in cell L5 and turn cell L5 yellow.

How can this be done? Thank you

Hello Karen,

This is what you need to put into cell L5,

=SUM(IF(J56.45,IF(J5<9.44,1,0),0))

You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get
{}, these brackets surrounding the equation if you did it right.



Format - Conditional Formatting

In the first box choose option "Cell Value Is"

In the second box choose option "Equal To"

In the third box type in the number 1

Then click FORMAT at the bottom go to

Second highlight the L cells you are working with go to TAB PATTERS and
choose your color, then click ok and ok again, whever that specific cell in
the L colomn see the number one it will make it yellow.

"Dan" wrote:

Hello Karen,

This is what you need to put into cell L5,

=SUM(IF(J56.45,IF(J5<9.44,1,0),0))

You have to enter it with, CTRL+SHIFT+ENTER all at the same time you'll get
{}, these brackets surrounding the equation if you did it right.

Second highlight the L cells you are working with go to TAB PATTERS and
choose your color, then click ok and ok again, whever that specific cell in
the L colomn see the number one it will make it yellow.

Dan
Format - Conditional Formatting

In the first box choose option "Cell Value Is"

In the second box choose option "Equal To"

In the third box type in the number 1

Then click FORMAT at the bottom go to

"Karen" wrote:

Would some please help me with this formula? I want the formula to reference
cell J5 - This is what I need: If cell J5 is 6.45 and <9.44, place a number
1 in cell L5 and turn cell L5 yellow.

How can this be done? Thank you

try putting what yyou would want ented in J5 doesnt meet the criteria instead
of "else"
=if(and(j56.45,J5<9.44),1,"else")
selecty cell L5
<format<conditional format
formula is =and(j56.45,J5<9.44)
and change format to yellow

"Karen" wrote:

Would some please help me with this formula? I want the formula to reference
cell J5 - This is what I need: If cell J5 is 6.45 and <9.44, place a number
1 in cell L5 and turn cell L5 yellow.

How can this be done? Thank you