#Value Error

[Spruce]

Hi All,

I'm assuming this is a formatting issue but everything I try doesn't seem to fix the #Value issue. My spreadsheet is setup like:

Merged Cell: DZ5:EL5 = "Fiscal Year 2018"
Cells above labelled: Jan, Feb, Mar, Etc. in sequential order.

Formula in cell DZ1 =VALUE(IF(DZ7="",LEFT(DY1,4),IF(DZ6="JAN",RIGHT(DZ5,4)&"01",IF(DZ6="Total",LEFT(DY1,4),DY1+1))))

which display 201801, 201802....201811, 201812

The formula seems to work fine but when the cells are "", which occurs right after 201812, returns a #Value , when it should return 2018. Also if I try to reference any of cells and do a calculation based on the values I get a #Value Error.

This formula has worked on the first 5 worksheets, but now on the last 2 it hasn't.

Help Please! Thanks!

 

[Spruce]

Also, on the other spreadsheets if I write the formula = DZ6 = "JAN", it returns TRUE, on this spreadsheet it returns 1.

 

[Spruce]

I figured it out. The transition formulas evaluation checkbox was set to true instead of false.