I am trying to create a formula, which I am not the best at. I seem to make
it too long. I want it to say if a cell = 2 or 3 it should be 1162. if it
is a 4, 5 or less than 637999 then it is 1172. If is is greater than 638000
then it should be 1162 everything else is 1162. Help!!

In article ,
says...
I am trying to create a formula, which I am not the best at. I seem to make
it too long. I want it to say if a cell = 2 or 3 it should be 1162. if it
is a 4, 5 or less than 637999 then it is 1172. If is is greater than 638000
then it should be 1162 everything else is 1162. Help!!

See the responses to the other post on the same subject.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Try this Sonia...

assumes that cell A1 has the value you want to use...

=IF(A1=4, IF(A1<=637999, 1172, 1162), 1162)

HTH.



"Sonia" wrote:

I am trying to create a formula, which I am not the best at. I seem to make
it too long. I want it to say if a cell = 2 or 3 it should be 1162. if it
is a 4, 5 or less than 637999 then it is 1172. If is is greater than 638000
then it should be 1162 everything else is 1162. Help!!

Sonia,
All your conditions appear to mean if cell =4 and <= 637999
then 1172, otherwise 1162.

Assumin data is in A1 then in B1 put:

=IF(AND(A1=4,A1<=637999),1172,1162)

"Sonia" wrote:

I am trying to create a formula, which I am not the best at. I seem to make
it too long. I want it to say if a cell = 2 or 3 it should be 1162. if it
is a 4, 5 or less than 637999 then it is 1172. If is is greater than 638000
then it should be 1162 everything else is 1162. Help!!