| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Two functions in one cell??? | Excel Worksheet Functions | |||
| Can you put two functions in one cell? | Excel Worksheet Functions | |||
| HOW DO I USE TWO IF FUNCTIONS IN ONE CELL? | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| # of Functions per cell >> More | Excel Worksheet Functions | |||
![Candentco Creative Collection[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
