X marks the spot

[BlueFeather]

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?

 

[Pete_UK]

Put this in B1:

=IF(A1="X",100,"")

Hope this helps.

Pete

 

[Gary''s Student]

In B1 enter:

=IF(A1="X",100,"")