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.
|