if statement with three different criterias?
 

I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

You don't say what you would like to do if B3 is between 12 and 25.
However, you might like to try this formula:

=IF(B3<=6,"Carton",IF(B3=25,"Full Pallet",IF(B3<=12,"1/2 Pallet","not
specified")))

Hope this helps.

Pete

On Feb 3, 1:24 am, tom wrote:
I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

You just need to nest the Ifs (and define what happens if be is between 13 and
24), as in:

=if(b3<6,"Carton",if(b3=25,"Full Pallet","1/2 Pallet"))

--
Regards,
Fred


"tom" wrote in message
...
I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

On Feb 2, 8:24 pm, tom wrote:
I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

This can be done with IF equations, but the easier way is to create a
user defined function (UDF) to return the value you want.

In the visual basic editor, insert a module and paste in the following
code:

Function Test(Value As Integer)
Application.Volatile

If Value < 7 Then
Test = "Carton"
ElseIf Value = 7 And Value <= 12 Then
Test = "1/2 Pallet"
ElseIf Value 25 Then
Test = "Full Pallet"
End If
End Function


Then, in cell D3, enter the following formula:

=Test(B3)


Hope that helps!

if statement with three different criterias?
 

=IF(B3<6,"Carton",IF(B3<12,"1/2 Pallet,IF(B3=25,"Full Pallet","")))

What do you want the result if B3 is between 13 and 24


"tom" wrote:

I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

Between 13 and 24 I would like the formula to return 1/2 Pallet.

Thanks for the help,
Tom

"Teethless mama" wrote:

=IF(B3<6,"Carton",IF(B3<12,"1/2 Pallet,IF(B3=25,"Full Pallet","")))

What do you want the result if B3 is between 13 and 24


"tom" wrote:

I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

One way:

=LOOKUP(B3,{0,1,7,25},{"","carton","1/2 pallet","full pallet"})

Biff

"tom" wrote in message
...
I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full
Pallet."

Thanks for the HELP,

if statement with three different criterias?
 

Or even:

=LOOKUP(B3,{0,1,7,13,25},{"","Carton","1/2 Pallet","","Full Pallet"})

or maybe:

=LOOKUP(B3,{0,1,7,13,25},{"","Carton","1/2 Pallet","3/4 Pallet","Full
Pallet"})

HTH
Jean-Guy

"T. Valko" wrote:

One way:

=LOOKUP(B3,{0,1,7,25},{"","carton","1/2 pallet","full pallet"})

Biff

"tom" wrote in message
...
I have a cell (B3) that has a number "7" and in cell (D3) I am trying to
write a formula to return the following:

If the cell is <6 I would like the formula return "Carton".
If the cell (B3) is between 7 and 12 I would like the formlua return "1/2
Pallet".
If the cell (B3) is 25 or greater, I want the formula to return "Full
Pallet."

Thanks for the HELP,