Forum Discussion
Excel formula malfunctioning
A little more information would help to be able to suggest a solution to you.
Welcome to your Excel discussion space!
Additional information such as Excel version, storage medium, what formula it is, what form of Excel file it is (.xlsx, .xlsm, etc.), a file (without sensitive data) or photos, certainly help.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- Also sorry it’s in .xlsx
Are the cells formatted correctly?
here is a small solution (cumbersome, but it works 🙂 , on the fly
ok so basically I have the name on two separate sheets and I’m using an if function to then input information linked to that name so (use your imagination a bit)
=IF(A2:A3=List!A2:B2,List!B4,” “)
but it’s duplicated into the cell next door to it however, it’s not written in Black, it’s written in light grey and giving the number but in a simple format ie 1.23E+09
