View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formula won't calculate

Check one of your other posts.

Be18 wrote:

I currently have the following formula

=IF(D12="SWR","Liz b",IF(D12="TCH","lex G",IF(D12="POS","Mav
H",IF(D12="INT","Rich H", IF(D12="FOU","Ton T",)))))

but when i click out of the box, it does not work out the value, the text
just remains - please can you tell me what is wrong with my formula and how
i can get it to calculate?

Thank you


--

Dave Peterson