Link the selection box to a cell using its properties. then your formula
can look at the cell.

--
Regards,
Tom Ogilvy

"DDONNI" wrote in message
...

Hi Guys, can anyone help me with this i'm sure the solution ain't too
bad.

I'm trying to use a selection box and from that use an if formula to
return a certain value depending on what's selected in the selection
box, the problem is i can't point the if statement to a cel as its a
selection and i don't know how to get it to look at the selection box.
Any ideas?

Donni.





--
DDONNI
------------------------------------------------------------------------
DDONNI's Profile:
http://www.excelforum.com/member.php...o&userid=15443
View this thread: http://www.excelforum.com/showthread...hreadid=274844