Well i'm trying to create a basic Base converter (starting in base 10 to whatever other base ) and just wondering how i would go about having excel dividing and giving me a remainder rather than a decimal or haveing it round a number down to the next integer I think that is all i can't figure out and if you have no idea white i'm talking about i can upload a sample excel file to show you and yes i'm aware that there are many base converting programs using java or pretty much any other programming language, but bases interest me and would just like to make this spreadsheet on my own so please be understanding and don't just link me a site that will convert my bases for me :tongue: Thanks K4D EDIT: just found round down, it's ROUNDDOWN but when i use it like =ROUNDDOWN(7.645,2) *The second number is something about how many digits not rly sure what but it does require it it will output 8 rather than rounding down to 7 like I want
actually it would just be =int so =int(7/3) would return 2 and =int(7.645) would return 7 *EDIT: just reread your post and see you want the remainder in that case its =MOD(number, divisor) so =mod(7,3) would return 1