+ Reply to Thread
Results 1 to 7 of 7

Online form with Google docs

  1. #1
    Registered User
    Join Date
    11-10-2008
    Location
    Dallas, Texas
    Posts
    4

    Online form with Google docs

    Ill do my best to explain this...

    I have an online form that I have created with Google forms - The form is set up as a

    1=Almost Never
    2
    3
    4=Almost Always

    and they rate the question 1-4 - After the questionnaire has all been answered then the results are automatically transferred to an good excel document - A made a second tab on the excel document and I am adding certain questions off the results page in to certain categories on the 2nd tab.

    I have no problem when I do =SUM and click on the cells i need to be added together from the results page - However some of the questions need to be reversed meaning
    1-Almost Always
    2
    3
    4-Almost never

    This is to ensure the honesty of their answers -

    Now when I go back to those certain questions -
    Is there some kind of
    =IFC2=1 than it equals 4 formula of some kind??
    and if there is do i need to
    say that 4 times with all the numbers in that one formula on that cell
    I am new to Excel and am trying this out- If anyone could help me out I would appreciate it

    thanks for your patience and time!

  2. #2
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421
    Ok...just to make sure I understand...you want 1-4 values to be reversed 4-1. If c2 is where the original value is then in the cell you want to show the modified value put the formula "=5-C2"

  3. #3
    Registered User
    Join Date
    11-10-2008
    Location
    Dallas, Texas
    Posts
    4
    Some of the questions need to be reversed
    meaning
    4=1
    3=2
    2=3
    1=4

    so in the original cell - i have the formula of certain questions being added together - this is the formula i have in one cell to add the cells together

    =SUM('Survey Results'!H2,'Survey Results'!T2,'Survey Results'!X2,'Survey Results'!AD2)


    Lets say that H2 was reversed - is that where i had H2-5 in ??

  4. #4
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421
    maybe this will help.

    If it doesn't...then I misunderstand what you are looking for.
    Attached Files Attached Files

  5. #5
    Forum Contributor GuruWannaB's Avatar
    Join Date
    01-24-2008
    Location
    An hour due East of Cowtown Ohio
    MS-Off Ver
    2010
    Posts
    421
    If you then wanted to sum the converted values...then yes, you would be right...H2,T2,X2,AD2 would be the cells with the conversion formula in it.

  6. #6
    Registered User
    Join Date
    11-10-2008
    Location
    Dallas, Texas
    Posts
    4
    That is exactly what I mean - Thank you
    now I am just not sure where I add it

    i==SUM('Survey Results'!H2,'Survey Results'!T2,'Survey Results'!X2,'Survey Results'!AD2)

    If that is the formula - do i put it inside that formula maybe like

    =SUM('Survey Results'!H2=5-H2,'Survey Results'!T2=5-T2,'Survey Results'!X2=5-X2,'Survey Results'!AD2=5-AD2)

  7. #7
    Registered User
    Join Date
    11-10-2008
    Location
    Dallas, Texas
    Posts
    4
    Awesome, I got it and it works perfectly - you are so great thank you so much =)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1