+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Excel 2007 - Calculations in Technical; Okay I have several values in one of my spreadsheets. For Example A A B C D E 1 5 ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Excel 2007 - Calculations

    Okay I have several values in one of my spreadsheets.

    For Example

    A A B C D E
    1 5 6 2 1 3
    2 7 16 12 2 4
    3 8 7 6 3 3
    4 2 3 9 7 4
    5
    6 1 1 0 1 0
    7 1 1 0 1 0
    8 1 1 0 1 0
    9 1 1 0 1 0
    10 1 1 0 1 0
    11 1 1 0 1 0
    12 1 1 0 1 0

    I would like to create a formula that says something along the lines of "if A1<6 and A6=1 then value of A15=1" but I would also like to have the statement say if A1<4 A15=2 A1<2 A15=3 et cetera is there anyway of doing this?


    Wes

  2. #2
    Jona's Avatar
    Join Date
    May 2007
    Location
    Cranleigh
    Posts
    467
    Thank Post
    14
    Thanked 50 Times in 48 Posts
    Rep Power
    23
    It's quite messy to do nested if's in excel but a good start might be here:
    http://pubs.logicalexpressions.com/P...cle.asp?ID=225

  3. #3

    Join Date
    Jan 2007
    Location
    Birmingham
    Posts
    807
    Thank Post
    29
    Thanked 36 Times in 24 Posts
    Rep Power
    26
    Wes,

    It might help if you gave some more details about the data. I.e. what defines what a15 is.

  4. #4
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,205
    Thank Post
    223
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    A15 is the result of a 1 in a6 - a12 and also what value is in A1-A4 <6, <3 <2 =0 et cetera


    Wes

SHARE:
+ Post New Thread

Similar Threads

  1. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM
  2. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  3. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM
  4. Excel IF statement maybe VB
    By danIT in forum General Chat
    Replies: 1
    Last Post: 5th January 2007, 12:12 PM
  5. Excel frustration
    By GrumbleDook in forum Windows
    Replies: 3
    Last Post: 24th August 2005, 10:01 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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