excel conditional formatting Closed

Question

can I make a cell = a value based on the value of another cell?
example: I want to make A2 = 5 if A1 <40.

venkat1926 · Answer

"example: I want to make A2 = 5 if A1 <40.
 Reply"

in A2 type this formula

=if(a1<40,5,"")

MJIMS · Answer

that works great! thanks! how can I make A2 =4 if A1 is between a range of 40-45?

Mazzaropi · Answer

MJIMS, Good afternoon.

"...how can I make A2 =4 if A1 is between a range of 40-45?..."

Try to use it:

A2 --> =IF(AND(A1>=40,A1<=45),4,"")

Is it what you want?
I hope it helps.

MJIMS · Answer

wonderful. works like a charm.......now can I combine the 2 into 1 cell?

=if(a1<40,5,"")
and....
=IF(AND(A1>=40,A1<=45),4,"")
together?

Mazzaropi · Answer

MJIMS, Good evening.

Try to use it:

A2 --> =IF(A1<40,5,IF(A1<=45,4,""))

Is it what you want?
I hope it helps.  
 --
Belo Horizonte, Brasil.
Marcílio Lobão

MJIMS · Answer

Wonderful. I added about 5 more expressions but you gave me the start I needed. Thank you.

Mazzaropi · Answer

MJIMS, Good morning. 

If you have a sequence of intervals to search for, maybe it's better to create a table and use a VLOOKUP function to do the job.

It's a very efficient tool for this kind of work.

Excel conditional formatting

7 responses

Similar discussions

Subscribe To Our Newsletter!