Results 1 to 2 of 2

Thread: Multiple IF Formula

  1. #1

    Multiple IF Formula



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



    Hi
    Can anyone help with the attached multiple if formula, I just need the final argument adding but don't seem to be able to sort it - Many Thanks in advance

    The current formula is =IF(B3="","",IF(B3=50%,IF(C2>0,C2*B3,C2/2),IF(C2>0,C2*10%,0)))

    DONE IF THE SHARE PERCENTAGE IS 50% THEN TIMES THE PROFIT BY THE PERCENTAGE IE RESULT SHOULD BE 120
    DONE IF THE SHARE PERCENTAGE 10% AND THE PROFIT IS NOT 0 OR LESS THAN 0 THEN SHOW 10% OF THE PROFIT, IE RESULT DEDUCTION IS 24
    DONE IF THE SHARE PERCENTAGE IS 10% BUT THE PROFIT IS 0 OR LESS THAN 0 JUST SHOW PROFIT IE RESULT IS 240
    DONE IF THE SHARE PERCENTAGE IS 50% BUT the PROFIT IS 0 OR LESS THAN 0 THE PROFIT SHARE SHOULD BE HALVED IE IF PROFIT WAS -50 THE RESULT SHOULD BE -25
    FIX IF THE SHARE % IS 0%, MAKE NO DEDUCTIONS FINAL PROFIT RESULT SHOULD BE 240
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,823
    Articles
    0
    Excel Version
    O365
    Is this what you mean?

    =IF(B3="","",IF(B3=50%,C2*B3,IF(B3=10%,IF(C2>0,C2*B3,C2),C2)))

Posting Permissions

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