how put "X" in a cell on a wksht if value of cell on another wksht is >12.4

  • Thread starter Thread starter vic
  • Start date Start date
V

vic

very amatuer question. sorry: trying to put an "X" in a
cell on a worksheet if the number in a cell from a
previous worksheet is > 12.4 (i.e. if a # in a particular
cell on a worksheet is > 12.4 then put an "X" in a
particular cell on another worksheet.)
much thanks and appreciation to anyone who can help.
vic
 
In that other sheet, a formula something like this:

=IF(Sheet1!A1>12.4,"X","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct using criteria from multiple columns in a separate wksh 1
Any math function on last 5 non zero or empty cells in a column 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy a formula to the right increasing the rows from another works 9
Hide columns based on row values 2
How do I have a cell value define a dynamic named range? 15
When a cell is blank, add another 2
Cell Referencing 5

Back
Top