S Sandy Mann Jun 1, 2008 #2 =B42*17.5% or: =B42*0.175 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
=B42*17.5% or: =B42*0.175 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
E eddiethemini Jun 1, 2008 #3 Thank you, I used the second one but it left a % sign, I forgot you could do it the easier way! its a lot of years since I did a spreadsheet course.
Thank you, I used the second one but it left a % sign, I forgot you could do it the easier way! its a lot of years since I did a spreadsheet course.
S Sandy Mann Jun 1, 2008 #4 You're very welcome. Thanks for the feedback -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
You're very welcome. Thanks for the feedback -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk