Dickey

You know the simple answer to this ;-)

You will need to look at the functions you are using to see if it can be
shortened, for example multiple IFs may be shortened by using a table and
VLOOKUPs for example. Without further info it's difficult to diagnose

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dickey" wrote in message
...
is there a way to get around the error "formula to long"