Background: Spreadsheet cell V2 = Jul12, W2 = Aug12, X2 = Sep12,Y2 = Q1FY12 (this goes on for 4 qtrs.) and then column AL2 = FY12 YTD
Column V230 states =if((sum(E229)=0,"",E229) (this cell is a prior year number that needs to be subtracted from current year number)
V231 states =if(iserror(v229-v230),"",V229-V230)
which works great. Gives what I need.
Column Y230 states =if(countblank(V230:X230)=3,"",SUM(V230,W230,X230)) - which again works great
but Y231 which states =if(iserror(Sum(V231:X231)),"",Y229-Y230) is not working - I get a #Value! return.. so obviously there is something wrong with this formula. I need help.
E229=1045 (current fiscal)
E230=1009
E231=36
--end of fiscal--
V229= (do not have current fiscal)
V230=1045 (prior fiscal)
Y229= (do not have current fiscal)
Y230= #Value!
Bookmarks