# Thread: Help with If Formula with multiple arguments

1. ## Help with If Formula with multiple arguments

Hi Can anyone help with the following

 A B 1 SHARE PROFIT 2 £240 3 10% OR 50%

Note A3 is a drop down with choice of 10% or 50%

 IF THE SHARE PERCENTAGE IS 50% THEN TIMES THE PROFIT BY THE PERCENTAGE IE RESULT SHOULD BE £120 IF THE SHARE PERCENTAGE 10% AND THE PROFIT IS NOT £0 OR LESS THAN £0 THEN SHOW 10% OF THE PROFIT, IE RESULT IS £24 IF THE SHARE PROFIT IS 10% BUT THE PROFIT IS 0 OR LESS THAN 0 JUST SHOW PROFIT IE RESULT IS £240 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  Reply With Quote

2. Try:

=IF(A3="","",IF(A3=50%,IF(B2>0,B2*A3,B2/2),IF(B2>0,B2*.1,B2)))  Reply With Quote

3. ##  Originally Posted by NBVC Try:

=IF(A3="","",IF(A3=50%,IF(B2>0,B2*A3,B2/2),IF(B2>0,B2*.1,B2)))

Brilliant thankyou  Reply With Quote

4. Ah just noticed an problem with it ...
When the Profit is a zero or minus and the percentage reads 10% the result should read 0  Reply With Quote

5. Just change the last argument

=IF(A3="","",IF(A3=50%,IF(B2>0,B2*A3,B2/2),IF(B2>0,B2*10%,0)))  Reply With Quote

6. ##  Originally Posted by Bob Phillips Just change the last argument

=IF(A3="","",IF(A3=50%,IF(B2>0,B2*A3,B2/2),IF(B2>0,B2*10%,0)))
Fabulous, thanks so much for your help  Reply With Quote

7. It could probably be shortened to:

=IF(A3="","",IF(B2>0,B2*A3,IF(A3=50%,B2/2,0)))  Reply With Quote

8. Thankyou both

Just to complicate matters if A3 were to read 0% I want B3 to also read 0, as currently it gives 10% of B2 - would it be possible to add that into the formula you provided?

Dave  Reply With Quote

9. Originally Posted by faodavid Thankyou both

Just to complicate matters if A3 were to read 0% I want B3 to also read 0, as currently it gives 10% of B2
Based on your latest addition to the parameters, try this in B3:

=IF(B2= 0,0, IF(A3=50%,A3*B2, IF(A3<> 10%, 0, IF(B2< 0,0,A3*B2))))

The logic assumes that any percentage apart from 10% and 50% will return 0.  Reply With Quote

#### Posting Permissions

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