| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
X marks the spot
I need help. I want to put an X in cell A1 when i put an x it will put the
number 100 in cell B1. if i dont put an X it will remail blank. Is this posiable? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
X marks the spot
Put this in B1:
=IF(A1="X",100,"") Hope this helps. Pete On Dec 11, 11:06*am, BlueFeather wrote: I need help. I want to put an X in cell A1 when i put an x it will put the number 100 in cell B1. if i dont put an X it will remail blank. Is this posiable? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
X marks the spot
In B1 enter:
=IF(A1="X",100,"") -- Gary''s Student - gsnu200819 "BlueFeather" wrote: I need help. I want to put an X in cell A1 when i put an x it will put the number 100 in cell B1. if i dont put an X it will remail blank. Is this posiable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to get the relative marks from a table of names,subjects & marks? | Excel Worksheet Functions | |||
| Hosur an IT hot spot? | Excel Worksheet Functions | |||
| 2 printers 1 does not print name in same spot | Excel Discussion (Misc queries) | |||
| I want a name in one spot and it's code in another | Excel Discussion (Misc queries) | |||
| SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions | |||
Hybrid Mode
