Result in one cell based on value in another cell

[Marq]

Using Excel 2007:

I'm needing two formulas in cell's O3 and P3 that basically says:

If the value in cell E3 is 4555 or 4556 then in this cell (O3) show YES

in the other cell (P3):

If the value in B3 begins with a number 6, then in this CELL show up as YES.

 

[JackDanIce]

Try this formula in E3:

=IF(OR(E3=4555, E3=4556),"YES")

Though you don't state what happens in E3 if it doesn't show either value

For P3 try:

=IF(LEFT(B3,1)=6,"YES")

Again you don't state what happens if the first character is not a 6

For any IF statement, always better to consider the two options if your condition matches or your condition doesn't match

 

[T. Valko]

Using Excel 2007:

I'm needing two formulas in cell's O3 and P3 that basically says:

If the value in cell E3 is 4555 or 4556 then in this cell (O3) show YES

in the other cell (P3):

If the value in B3 begins with a number 6, then in this CELL show up as YES.

Try these...

For O3:

=IF(OR(E3={4555,4556}),"Yes","")

For P3:

=IF(LEFT(B3)="6","Yes","")

 

[texasalynn]

try this

Excel Workbook
	O	P
3	Yes	Yes
Sheet1

Excel 2003

Cell Formulas
Range	Formula
O3	=IF(OR(E3=4555,E3=4556),"Yes","")
P3	=IF(LEFT(TEXT(B3,"00"),1)="6","Yes","")

 

[T. Valko]

For P3 try:

=IF(LEFT(B3,1)=6,"YES")

Since the LEFT function returns a TEXT value LEFT(B3,1)=6 will NEVER be TRUE.

You have to either quote the 6 or coerce the result of LEFT.

It'd be easier and more robust to quote the 6:

=IF(LEFT(B3,1)="6","YES")

 

[Marq]

I left out the second part of the equation..sorry about that...this is what im needing:

I'm needing two formulas in cell's O3 and P3 that basically says:

If the value in cell E3 is 4555 or 4556 then in this cell (O3) show YES, but if the value in E3 is 7555 or 7556 then show NO

in the other cell (P3):

If the value in B3 begins with a number 6, then in this CELL (P3) show up as YES...or if the value in B3 begins with a 9 then show NO in the cell (P3)

 

[John Davis]

I left out the second part of the equation..sorry about that...this is what im needing:

I'm needing two formulas in cell's O3 and P3 that basically says:

If the value in cell E3 is 4555 or 4556 then in this cell (O3) show YES, but if the value in E3 is 7555 or 7556 then show NO

in the other cell (P3):

If the value in B3 begins with a number 6, then in this CELL (P3) show up as YES...or if the value in B3 begins with a 9 then show NO in the cell (P3)

O3:

=IF(OR(E3=4555,E3=4556),"Yes","No")

P3:

=IF(LEFT(B3)="6","Yes",IF(LEFT(B3)="9","No",""))

 

[T. Valko]

I left out the second part of the equation..sorry about that...this is what im needing:

I'm needing two formulas in cell's O3 and P3 that basically says:

If the value in cell E3 is 4555 or 4556 then in this cell (O3) show YES, but if the value in E3 is 7555 or 7556 then show NO

in the other cell (P3):

If the value in B3 begins with a number 6, then in this CELL (P3) show up as YES...or if the value in B3 begins with a 9 then show NO in the cell (P3)

For O3:

=IF(OR(E3={4555,4556}),"Yes",IF(OR(E3={7555,7556}),"No",""))

For P3:

=IF(LEFT(B3)="6","Yes",IF(LEFT(B3)="9","No",""))

 

[Marq]

For O3:

=IF(OR(E3={4555,4556}),"Yes",IF(OR(E3={7555,7556}),"No",""))

For P3:

=IF(LEFT(B3)="6","Yes",IF(LEFT(B3)="9","No",""))

works perfect!..Thanks!

 

[T. Valko]

works perfect!..Thanks!

You're welcome. Thanks for the feedback!