+ Reply to Thread
Results 1 to 8 of 8

Formula to calculate single cell based on many variables

  1. 12-12-2011, 11:40 PM #1
    malawimick
    malawimick is offline
    Registered User
    Join Date
    12-12-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Formula to calculate single cell based on many variables

    I have just joined this forum - as I am in trouble with a complicated formula per attached file.

    Trying to get result per criteria in the table using formulas rather than VBA(don't understand it)

    Please see attached file for details

    Can some one put me on the right track please?

    Thank you!!!!
    Attached Files Attached Files
    Last edited by malawimick; 12-14-2011 at 08:09 PM. Reason: updated file attached
    Reply With QuoteRegister To Reply
  2. 12-13-2011, 01:33 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Complicated formula help

    It will be good if you specify the conditions. Its tough to identify them ourselves by looking at your file.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 12-13-2011, 02:38 AM #3
    malawimick
    malawimick is offline
    Registered User
    Join Date
    12-12-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Complicated formula help

    Thanks for your comments Arlette.

    I can see how it could be confusing - now I will write out some consise details and repost later.

    Cheers
    Malawimick
    Reply With QuoteRegister To Reply
  4. 12-13-2011, 03:32 PM #4
    malawimick
    malawimick is offline
    Registered User
    Join Date
    12-12-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Complicated formula help

    Thank you RoyUK I have done what you asked - hope this is what you mean.
    I will post updated file later today per Arlette's reply.
    Thank you everyone for your help
    Reply With QuoteRegister To Reply
  5. 12-14-2011, 08:14 PM #5
    malawimick
    malawimick is offline
    Registered User
    Join Date
    12-12-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Complicated formula help

    Hi Fellow Members,

    If someone can help me before tomorrow then that would be great as I am going away for Xmas and I promised to get the results back to a friend I am trying to help.

    Cheers,
    Malawimick
    Reply With QuoteRegister To Reply
  6. 12-14-2011, 09:40 PM #6
    Wolfe_Tones
    Wolfe_Tones is offline
    Registered User
    Join Date
    07-15-2010
    Location
    Dundalk Ireland
    MS-Off Ver
    Microsoft Office Home and Student 2007
    Posts
    3

    Re: Formula to calculate single cell based on many variables

    cell c4 =IF(H6>11,P10+P11+P12,IF(H6>=6,P10+P11,IF(H6<6,P10)))

    cell c20 =IF(H22>=11,P13+P14+P15,IF(H22>=6,P13+P14,IF(H22<6,P13)))

    cell c21 =IF(I22>=11,Q13+Q14+Q15,IF(I22>=6,Q13+Q14,IF(I22<6,Q13)))
    Reply With QuoteRegister To Reply
  7. 12-14-2011, 10:04 PM #7
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Formula to calculate single cell based on many variables

    Hello
    malawimick
    Happy Vacation
    Used If statements -- just table 1
    Choose


    Copy of Point Formula.xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  8. 12-15-2011, 02:13 AM #8
    malawimick
    malawimick is offline
    Registered User
    Join Date
    12-12-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Formula to calculate single cell based on many variables

    Thanks Vlady

    Just need to understand how your formula works now because my data uses 3 worksheets- your a real Genie!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1