ExcelBanter - X marks the spot

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

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

- - X marks the spot (https://www.excelbanter.com/excel-discussion-misc-queries/213258-x-marks-spot.html)

BlueFeather

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?

Pete_UK

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?

Gary''s Student

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?

All times are GMT +1. The time now is 07:26 PM.