Previous Topic Next Topic

Excel formula problem

Solved/Closed
Stormdronk - 4 Apr 2011 à 02:49
 Stormdronk - 4 Apr 2011 à 05:54
Hello,

Please Help


=IF(V12=1,2*(R12*50%))


I have a problem with this formula: What I need, is if v12 = 1, 2, 3, or 4 count R12 times 50%

What should happen is that 1 counts 50% 2 counts 30% and 3 counts 20%

I have 3 columns column 1 counts 50% if v12 = 1 column 2 counts 30% if v12=2 and column 3 counts 20% if v12 = 3

Thanks
Related:

2 responses

Réponse 1 / 2
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
4 Apr 2011 à 04:19
please provide a sample of how your sheets look like or upload a sample of your workbook using a site like www.speedyshare.com. Also re-explain what you would like to see happen in more detail for better understanding.
Stormdronk
4 Apr 2011 à 04:42
Ok Thanks, hope this helps

Sale 50% 30% 20% Status

R 10,000.00 R 5,000.00 R 3,000.00 R 2,000.00 1

I have a sales value of 10 000, if my status is 1 then 50 30 and 20% must show and calculate, but if status is 2 the 50% shows false or 0 and 30 and 20 counts/ show, same with status 3, 50 and 30 dont count / false, only 20% show.

Thanks
Réponse 2 / 2
Stormdronk
4 Apr 2011 à 05:54
=IF(AND(OR(V12={1,2,3})),AE12)

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses