# Excel formula problem

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

=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

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.
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)