Hi Can anyone help with the following
Note A3 is a drop down with choice of 10% or 50%
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 |