Wednesday, December 17, 2008

happy holidays from vlookups

=IF(ISERROR(VLOOKUP(A7,Total,8,FALSE)),0,VLOOKUP(A7,Total,8,FALSE))-(Balance!B9*1000)

Monday, December 15, 2008

how do you like it?

=IF($A53<=Q$42, Sheet3!Q32/Sheet3!Q13, "")