| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help
I am trying to write an argument that states if aq3=bi3 and f3=bm3. if
true return a 1 if false return a 0. Everytime i try to write it i get an error, cell aq3 has a formula in it but i dont think it would cause this problem. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help
=IF(AND(AQ3=BI3,F3=BM3),1,0)
" wrote: I am trying to write an argument that states if aq3=bi3 and f3=bm3. if true return a 1 if false return a 0. Everytime i try to write it i get an error, cell aq3 has a formula in it but i dont think it would cause this problem. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help
=AND(AQ3=BI3,F3=BM3)*1
" wrote: I am trying to write an argument that states if aq3=bi3 and f3=bm3. if true return a 1 if false return a 0. Everytime i try to write it i get an error, cell aq3 has a formula in it but i dont think it would cause this problem. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help
On Feb 24, 2:51?am, Toppers wrote:
=IF(AND(AQ3=BI3,F3=BM3),1,0) " wrote: I am trying to write an argument that states if aq3=bi3 and f3=bm3. if true return a 1 if false return a 0. Everytime i try to write it i get an error, cell aq3 has a formula in it but i dont think it would cause this problem.- Hide quoted text - - Show quoted text - Thank you for your help, i see where i was going wrong. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
