Its big and its not clever, but it will tell you how much your spending per year on domains based on a column of them:
=IF(ISERROR(FIND(“www.”,BB17)),0,(IF(ISERROR(FIND(“.co.uk”,BB17)),0,2.99) +
IF(ISERROR(FIND(“.com”,BB17)),0,8.99)+ IF(ISERROR(FIND(“.org”,BB17)),0,8.99)+
IF(ISERROR(FIND(“.info”,BB17)),0,2.99)+ IF(ISERROR(FIND(“.net”,BB17)),0,8.99)+
IF(ISERROR(FIND(“.me”,BB17)),0,15.99)+ IF(ISERROR(FIND(“.eu”,BB17)),0,8.99)))
Comments Archive
Hi there. This is my old blog and it's archived, so you can no longer post new comments on this post (Excel Domain Cost Formula).
Read my new blog about writing software and stories at WoodyHayday.com