| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" formula not working- seems to be formatting
Hi All
I have a formula in Col B =if(G2"99999","StaffType1","StaffType2"),"") Col G has the staff employee numbers in it which if they are a 5 digit number they show a StaffType2 officer and if a 7 digit number show StaffType1. I use this with the download from SAP which is cut and pasted into D2 to O2 onwards. My formula was working. But if I keep trying it (and I can't seem to deliberately replicate), sometimes it shows everyone as StaffType1. I am thinking a format problem in column G as if I just click in each G cell and enter, it seems to correct itself. But I can't do this for all the cells or I'll go mad!! I have tried General, text and number formats because I am running out of ideas. Cheers Gai |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diff. change headline in "Formatting" or "Outlining" toolbar? | Excel Discussion (Misc queries) | |||
| Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Working out age from "Day" "Month" "Year" | Excel Worksheet Functions | |||
| Formula not working -- =SUMIF($F$6:$F$91,"=90",G6:I91) | Excel Discussion (Misc queries) | |||
Threaded Mode
