Excel formula problem [Solved/Closed]

Report
-
 Stormdronk -
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 replies

Posts
368
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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
=IF(AND(OR(V12={1,2,3})),AE12)