| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF X = Reverse of Y True = 1 False = 0
How do i get excel to do this?
I want the formula to look at cell 3D and if it is the exact reverse of cell 3B then enter 1 in cell 3E or if it's not enter 0 in 3E. How can i do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF X = Reverse of Y True = 1 False = 0
Define reverse.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brad Larsen" wrote in message ... How do i get excel to do this? I want the formula to look at cell 3D and if it is the exact reverse of cell 3B then enter 1 in cell 3E or if it's not enter 0 in 3E. How can i do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF X = Reverse of Y True = 1 False = 0
in your cell =if(x=1/y,1,0)
-- paul remove nospam for email addy! "Brad Larsen" wrote: How do i get excel to do this? I want the formula to look at cell 3D and if it is the exact reverse of cell 3B then enter 1 in cell 3E or if it's not enter 0 in 3E. How can i do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF X = Reverse of Y True = 1 False = 0
yes=sey ?
102=201 ? Biff "Bob Phillips" wrote in message ... Define reverse. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brad Larsen" wrote in message ... How do i get excel to do this? I want the formula to look at cell 3D and if it is the exact reverse of cell 3B then enter 1 in cell 3E or if it's not enter 0 in 3E. How can i do this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF X = Reverse of Y True = 1 False = 0
If the cell reads "1-2-4-3-7-6"
I want it to check for a reverse of "6-7-3-4-2-1" Thanks for your help. "Bob Phillips" wrote: Define reverse. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Brad Larsen" wrote in message ... How do i get excel to do this? I want the formula to look at cell 3D and if it is the exact reverse of cell 3B then enter 1 in cell 3E or if it's not enter 0 in 3E. How can i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorten a Macro | Excel Discussion (Misc queries) | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
| Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
Linear Mode
