November 3, 200718 yr Basically I just need a formula version of '=if(Cell has more than 8 digits' Does anyone know what i need to type or if it is possible to do this in excel? (I know it is possible to do this in Access but I'm required to do it in excel) Thanks, Brad Deviant Art Account2 Signatures | 6 Photographs | 1 Other
November 3, 200718 yr Like and 8 digit number? if([cell id thing]>9999999,[what to do if it is],[what to do if its not]) Last.fm Signature Overlays
November 3, 200718 yr Author Oh god.. so simple, thanks, i was thinking it was gonna be something like that but i was thinking more advanced, thanks :) Deviant Art Account2 Signatures | 6 Photographs | 1 Other
November 10, 200718 yr yeah i did an if command for my it coursework. very simple. if X is bigger than Y then Z. If X is smaller than Y then P. That is a simple one. Z is what you wnat to happen if X is bigger than Y for example no comes uo in the box. if X is smaller than Y then you might want yes to cpome up for example. This is P. Goals achieved: lvl 99 Cooking, Fishing and Fletching.Surrey CC and Liverpool FC fan for life!
Create an account or sign in to comment