Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting #VALUE
In the cells below, shows the formulas with resulting value below
it.......What would cause the #value? A1 Gretchun B3 0.65 A7 Forumla =IF('[Cleaning Schedule.xls]Cleaning History'!$A2=$A$1,'[Cleaning Schedule.xls]Cleaning History'!$B2,"") =if ( Erik = Gretchun, 11/2/2006,"") A7 Value "" B7 Formula =IF(A7<"",'[Cleaning Schedule.xls]Cleaning History'!$C2,"") Boat Name B7 Value "" C7 Formula =IF(B7<"",VLOOKUP(B7,'[Boats and Marinas.xls]Active Boats'!$B$3:$C$203,2,FALSE),"") Boat Footage C7 Value "" D7 Formula =C7*$B$3 D7 Value #Value E7 Formula =IF(MONTH(A7)=11,D7,"") E7 Value #Value However, where C7 is not blank, D7 evaluates correctly Date Boat Footage Pay 7 #VALUE! 8 #VALUE! 9 #VALUE! 10 #VALUE! 11 #VALUE! 12 #VALUE! 13 11/2/2006 PERSHING 53 $ 34.45 Thank you for any help, Don |