RogerKMiller

asked on

# Excel formula, IF statement, shows on spreadsheet and shouldn't

I'm writing a simple macro to check formulas and make sure they're correct on multiple spreadsheets in a given workbook; however, I noticed in one section of the spreadsheets there are formulas that pick up info from the Wednesday schedule. If that cell on Wednesday schedule is blank then the cell on the other spreadsheets are blank otherwise the content of the Wednesday cell shows, as they should. However, if I have the macro put the formula into the cell or if I manually write the formula into the cell it shows the formula rather than reading the Wednesday schedule. It is not formatted to show formulas and if I copy a pre-existing formula and paste it into the cell that shows the formula I wrote, the formula disappears, as it should, on the spreadsheet and can only be seen in the formula bar. I have no idea how or why this happens.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Thank you! I should have known that!

can you post the code you are using and/or the workbook? Maybe there is a leading space before the = sign?

cheers, teylyn