Dave thansk but it did not work

I need G3:G10 that contains X to change to A when F3 does NOT = "Current".

Jennifer

"davesexcel" wrote:


Jennifer1960 Wrote:
Need help to write formula or suggest a way of doing.

When Cell F3 is not equal to "CURRENT"
then where (G3:G10) contains X
change X to A.if there are only 7 rows, maybe this could work,enter this formula in
each of the cells G3:G10
=if($F$3="CURRENT","A","X")

or maybe you need this in each cell

=IF(F3="CURRENT","A","X")
=IF(F4="CURRENT","A","X")
=IF(F5="CURRENT","A","X")
=IF(F6="CURRENT","A","X")
=IF(F7="CURRENT","A","X")
=IF(F8="CURRENT","A","X")
=IF(F9="CURRENT","A","X")
=IF(F10="CURRENT","A","X")


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574452