Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
what I want to do is enter an X in cell N33 which put 100% in G33
What would be the formula |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |