View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nikki Nikki is offline
external usenet poster
 
Posts: 24
Default Return value based on checkboxes selected -- IF() LOOKUP()

On Apr 17, 1:10 pm, William Horton
wrote:

Bill,

Thank you for your reply.

<snip

Hope this helps.



Yes, this works great.






I did alter it a bit to return a string "N/A" if no checkboxes are
selected, by a simple IF() function.

Thank you again,
Nikki

Bill Horton