+ Reply to Thread
Results 1 to 4 of 4

Condition for formula required

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

    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
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,418

    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-01-2016, 09:07 AM #3
    CPAC
    CPAC is offline
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Re: Condition for formula required

    Superstar thank you.
    Reply With QuoteRegister To Reply
  4. 06-01-2016, 09:26 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,418
    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