Search results for query: *

Hi I have a sheet which calculates a value between 0-29 based on other cells in the sheet. What I want to do is have a condition returned dependent upon the number range, for example, 0-5 returns the word "green", 6-8 returns "amber" and 9-27 returns "red". I can do this over three...

Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...

Hi All I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment. I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the...

Hi all I am also trying to write a questionnaire. Ideally people will put an X in one cell to indicate their preference. Each answer will then have a score. How do I SUM on the condition that one cell has an X in it and the adjacent cell has the relevant number, is it something like COUNTIF and...

Hi Newbie here so I hope I have the right board... Two questions... Trying to write a formula which captures risk and liklihood. What I am after is a cell to display a text value depending on whether the previous two cells contain Low, Medium or High text values. So H/H would return one...

Hi all Newbie here. I am trying to show % complete values as graphical RAGG indicators - please could someone help? I have managed to work out how to put the circles in and also how to lift the percentage complete value - I just can't seem to apply conditions to the figure after that, i.e...