Thread: Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 5
Default Excel


Jim K. wrote:
what I want to do is enter an X in cell N33 which put 100% in G33
What would be the formula


I'm not exactly sure what you are talking about, but if you are saying
that when you put an "X" in N33, it will produce "100%" in G33, then
write the following formula in G33:

=IF(N33="X",1,0)

You would have to format cell G33 to a percentage as well.
FormatCellNumber tab, percetnage.