Brad25891 Posted November 3, 2007 Share Posted November 3, 2007 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 Link to comment Share on other sites More sharing options...
Errdoth Posted November 3, 2007 Share Posted November 3, 2007 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 Link to comment Share on other sites More sharing options...
Brad25891 Posted November 3, 2007 Author Share Posted November 3, 2007 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 Link to comment Share on other sites More sharing options...
Alex_Ewan_1 Posted November 10, 2007 Share Posted November 10, 2007 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now