| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula
Hi,
I'm trying to return a string if either of 2 conditions are present in the same cells. I'm trying to run with =IF(AND(R$2=6,$A5="Weekly"),"Report",IF(AND R4=TRUE,N5="Monthly"),"Report","")) What I want is if R2=6 and A5=weekly to return Report OR if R4=True and N5=Monthly to return Report ......otherwise remain blank. Any ideas ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
=if(or(and(R$2=6,$A5="Weekly"),AND (R4=TRUE,N5="Monthly")),"Report","")
"DamienO" wrote: Hi, I'm trying to return a string if either of 2 conditions are present in the same cells. I'm trying to run with =IF(AND(R$2=6,$A5="Weekly"),"Report",IF(AND R4=TRUE,N5="Monthly"),"Report","")) What I want is if R2=6 and A5=weekly to return Report OR if R4=True and N5=Monthly to return Report ......otherwise remain blank. Any ideas ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
Thanks bj
"DamienO" wrote: Hi, I'm trying to return a string if either of 2 conditions are present in the same cells. I'm trying to run with =IF(AND(R$2=6,$A5="Weekly"),"Report",IF(AND R4=TRUE,N5="Monthly"),"Report","")) What I want is if R2=6 and A5=weekly to return Report OR if R4=True and N5=Monthly to return Report ......otherwise remain blank. Any ideas ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Linear Mode
