ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/107145-excel.html)

Jim K.

Excel

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

Paul

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.

Gary''s Student

Excel

In G33 enter:
=IF(N33="X","100%","")
--
Gary's Student

"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

All times are GMT +1. The time now is 03:41 PM.