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 %


    IF C=0 then A/B * 100

    I've tried the following (also attached):


    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.

    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    You just need to divide the result by 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