+ Reply to Thread
Results 1 to 2 of 2

Conditional If Statement with percent

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Conditional If Statement with percent

    Hi everyone-

    I'm trying to figure out the formula that will place the word "yes" if cell A is less than 25% of cell C.

    For example, "Yes" if cell A1 (Quantity in stock) is less than 25% of C1 (Quantity in reorder), or "No" if this condition is no met.

    Values:

    A1-325
    B1-??
    C1-1000

  2. #2
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Conditional If Statement with percent

    if you want to hard code it, you can use this..

    =IF(A1/C1<0.25,"Yes","No")

    325/1000 is 33% percent so it would be No correct?

+ 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