Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel question borderline programing
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 . thank you duane |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel question borderline programing
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
excel novice question on filling in missing fields/cells | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |