Results 1 to 3 of 3

Thread: Struggling with an IF Function

  1. #1

    Struggling with an IF Function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys,

    New to the forum and I'm having some difficulties with an IF forumula that no matter what I try I can't get my head round. I think it's because I'm trying to join 2 seperate IF statements into one formula.

    I've got 3 values, A, B and C.

    I want the formula to look at Cell F2 and if it says "No" to display "*" in the cell. If it doesn't say "No" it'll carry out the following formula:

    IF C >=1 then A/B*100-10.1 to display as a %

    However

    IF C=0 then A/B * 100

    I've tried the following (also attached):

    =IF(F2="No","*",(IF(C2>=1,(A2/B2*100-10.1),(A2/B2*100))))

    I think I'm sort of close as it does what I want it to do but it's displaying the results as 8323.33% which I obviously don't want for a %. The actual answer should be 83.23%.

    Any help greatly appreciated.

    Thanks.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,491
    Articles
    0
    Excel Version
    Excel 2016
    You just need to divide the result by 100.

    =IF(F2="No","*",(IF(C2>=1,(A2/B2*100-10.1),(A2/B2*100))/100))


  3. #3
    Thanks very much!

    Just me being a clown then.

Posting Permissions

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