ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If and Or Functions in Same Cell (https://www.excelbanter.com/excel-worksheet-functions/139832-if-functions-same-cell.html)

Candentco Creative Collection[_2_]

If and Or Functions in Same Cell
 
Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)3%)),(ABS(F35/e35)3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!
--
MVD
San Francisco, California

JE McGimpsey

If and Or Functions in Same Cell
 
One way:

=IF(OR(ABS(F35/D35)3%, ABS(F35/E35)3%), "Yes", "-")

In article ,
Candentco Creative Collection
.com wrote:

Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)3%)),(ABS(F35/e35)3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!


Teethless mama

If and Or Functions in Same Cell
 
Save your last hair

=IF(or(ABS(F35/D35)3%,ABS(F35/e35)3%),"Yes","-")



"Candentco Creative Collection" wrote:

Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)3%)),(ABS(F35/e35)3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!
--
MVD
San Francisco, California


Candentco Creative Collection[_2_]

If and Or Functions in Same Cell
 
My hair and all those who might view it, thank you!!!
--
MVD
San Francisco, California


"Teethless mama" wrote:

Save your last hair

=IF(or(ABS(F35/D35)3%,ABS(F35/e35)3%),"Yes","-")



"Candentco Creative Collection" wrote:

Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)3%)),(ABS(F35/e35)3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!
--
MVD
San Francisco, California


Candentco Creative Collection[_2_]

If and Or Functions in Same Cell
 
The world should be grateful for you smart pros that save our lesser smart _
_ _ _s!
--
MVD
San Francisco, California


"JE McGimpsey" wrote:

One way:

=IF(OR(ABS(F35/D35)3%, ABS(F35/E35)3%), "Yes", "-")

In article ,
Candentco Creative Collection
.com wrote:

Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)3%)),(ABS(F35/e35)3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!




All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com