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

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
 
M

Myrna Larson

In that other sheet, a formula something like this:

=IF(Sheet1!A1>12.4,"X","")
 
Top