i think you can change fuction IF with LOOKUP .
Write more information about what are you trying to do.

--
M.A.
"Heindrich" <Heindrich @discussions.microsoft.com wrote in message ...


I am busy programming a work sheet in exel 2003. I need to have more than 7
If functions in one of my formulas to pick up correct amounts. How do I do
this as excel only allows for 7.