Formulas just not working?

Jschueller

New Member
Joined
Sep 15, 2014
Messages
2
Hi and thanks for reading.

I'm sure this is just some sort of mistake I'm making, but I have a sheet set up as shown below. Just trying to get column B's value to
to show up in the corresponding cell in columns E:K if the formula evaluates appropriately. This worked out fine in column E, but the formulas in F just don't seem to be evaluating at all. Did I copy the array over incorrectly or something? This is driving me nuts.

Thanks!



 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
What does the Evaluate Formula tool tell you about the values in the referenced cells? Are they all serial dates?
 

Jschueller

New Member
Joined
Sep 15, 2014
Messages
2
What does the Evaluate Formula tool tell you about the values in the referenced cells? Are they all serial dates?

Sheesh, that was it. Boy do I feel dumb. Only cells a1 and a2 were evaluating as serial dates. Making the change to the rest of column a solved the issue. Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,487
Messages
5,529,154
Members
409,851
Latest member
Ingar
Top