![]() |
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 |
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! |
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 |
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 |
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