Previous Topic Next Topic

Excel formula problem

Solved/Closed
Stormdronk - Apr 4, 2011 at 02:49 AM
 Stormdronk - Apr 4, 2011 at 05:54 AM
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

2 responses

Answer 1 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 4, 2011 at 04:19 AM
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.
1
Stormdronk
Apr 4, 2011 at 04:42 AM
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
0
Answer 2 / 2
Stormdronk
Apr 4, 2011 at 05:54 AM
=IF(AND(OR(V12={1,2,3})),AE12)
0

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
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response