excel question borderline programing

[gimp]

here is what i am trying to do. lets say i want cell a1 to reflect upon
cell b1. b1 can represnt 1 of 2 things what ever it may be. if b1
contains lets say x or (2pm-6pm) to make cell a1 represent an (*). but
if b1 then has y or somthing like (req off) make a1 either be 0 or
better yet be blank. is this possible? email me (e-mail address removed).
thank you

duane

 

[MartinW]

Hi Duane,

Put =IF(B1="x","*","") in cell A1 if you want it to return blank
or =IF(B1="x","*",0) if you want it to return 0

HTH
Martin