Hello Everyone,

Would appreciate some help on this...

i have created a spreadsheet to determine how many miles i drive on a monthly basis and i wanted to create a formula to do this for me.
For example, when i first started i used the following information:

h-w (home to work) 4 Miles
h-gf (home to girlfriends) 8 Miles
h-f (home to football) 10 Miles
h-c (home to cinema) 17 Miles

...and i used the formula =IF(B11="h-w","4",IF(B11="h-gf","8",IF(B11="h-f","10",IF(B11="h-c","17"))))

meaning that if write "h-w" in B11 then C11 shows "4", if i put "h-gf" it would show "8", and so on...

This worked fine until i added more circumstances. Now i have 15, it comes up with an error message " The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format", i can only put in 7 before this error message comes up...

How can i do i increase the amount of levels of nesting?
Or is there a different formula that u can use?

Please help,

Thanks!
Jamie