+ Reply to Thread
Results 1 to 4 of 4

Condition for formula required

  1. 06-01-2016, 08:43 AM #1
    CPAC is offline
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    132

    Condition for formula required

    Hi,

    I'm need to adapt the formula in cell B8 to allow for dimensions in cell B5 that are greater than 1210.

    =ROUNDDOWN(B4/B5,0)*ROUNDDOWN(C4/C5,0)*D5

    I need to add that if B5 is greater than B4 the value would be 1. I think it should look something like this???

    =ROUNDDOWN(IF(B4>B5,1,(B4/B5,0))*ROUNDDOWN(C4/C5,0))*D5

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-01-2016, 08:51 AM #2
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015

    Re: Condition for formula required

    This possibly?

    =If(B5>B4,1*ROUNDDOWN(C4/C5,0)*D5,ROUNDDOWN(B4/B5,0)*ROUNDDOWN(C4/C5,0)*D5)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-01-2016, 09:07 AM #3
    CPAC is offline
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    132

    Re: Condition for formula required

    Superstar thank you.
    Reply With QuoteRegister To Reply
  4. 06-01-2016, 09:26 AM #4
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,015
    Quote Originally Posted by CPAC View Post
    Superstar thank you.
    You're welcome!
    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)

Similar Threads

  1. [SOLVED] Excel formula to meet the condition as required
    By PRADEEPB270 in forum Excel General
    Replies: 3
    Last Post: 02-13-2017, 07:25 AM
  2. Condition Required to count
    By kkrueger in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-06-2014, 09:11 PM
  3. [SOLVED] formula required to list cell values based on condition
    By kiranpat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 04:54 AM
  4. [SOLVED] Need Help to Extract data from required tab as per condition
    By Naveed Raza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 01:54 AM
  5. Check if any cell in range fulfills required condition
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-20-2012, 10:59 AM
  6. Double lookup condition required
    By heatwave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2009, 05:38 PM
  7. Formula Required For IF Condition
    By Reyan123 in forum Excel General
    Replies: 2
    Last Post: 03-09-2009, 03:57 PM

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