| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
incorrect output of if formula
I have two cells with values which were macro auto copied from other cells by
copy - paste special value, I have a =if(A1=A2,"yes","no") formula in third cell to compare these two cells. From time to time the output of formula gives inccorrect answer, but if I copy the first cell to the second cell again manually using copy paste function, the third cell gives the right answer. Any idea why and how to correct this please? Rgds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting atuofilter incorrect output | Excel Discussion (Misc queries) | |||
| formula output | Excel Worksheet Functions | |||
| How do I use a referenced cell's formula instead of formula output? | Excel Worksheet Functions | |||
| add text to end of formula output | Excel Discussion (Misc queries) | |||
| formula for custom output | Excel Discussion (Misc queries) | |||
Threaded Mode
