Excel If Statements with more than one Solution

M

mjameson1144

How can I put all of three of these if statements into one cell? For
example I want to say if it equals the 1st one than this is true but if
it equals the 2nd one than this is true, if it equals the 3rd one than
this is true but if it doesnt equal any of them its 0

1st IF statement for
J13: =IF(YEAR($G12)=YEAR(J$12),IF(MONTH($G3)=MONTH(J$12),(($D4*$E3)*50%),"
")," ")
2nd IF statement for
J13: =IF(YEAR($G12)=YEAR(F$8),IF(MONTH($G12)=MONTH(F8),(($D12*$E12)*25%),"
")," ")
3rd IF statement for
J13: =IF(YEAR($G12)=YEAR(I$7),IF(MONTH($G12)=MONTH(I$7),(($D12*$E12)*25%),"
")," ")
 
M

Maistrye

How can I put all of three of these if statements into one cell? Fo
example I want to say if it equals the 1st one than this is true but i
it equals the 2nd one than this is true, if it equals the 3rd one tha
this is true but if it doesnt equal any of them its

1st IF statement fo
J13: =IF(YEAR($G12)=YEAR(J$12),IF(MONTH($G3)=MONTH(J$12),(($D4*$E3)*50%),
")," "
2nd IF statement fo
J13: =IF(YEAR($G12)=YEAR(F$8),IF(MONTH($G12)=MONTH(F8),(($D12*$E12)*25%),
")," "
3rd IF statement fo
J13: =IF(YEAR($G12)=YEAR(I$7),IF(MONTH($G12)=MONTH(I$7),(($D12*$E12)*25%),
")," "
Click to expand...

I'm not going to copy what you have, but it's basically like this

=IF(and([conditionsfor1]),[ResultFor1], IF(and([conditionsfor2])
[ResultFor2], IF (and[conditionsfor3]), [ResultFor3]
[ResultForNone]))

Where, for example, [conditionsfor1] i
YEAR($G12)=YEAR(F$8),(MONTH($G12)=MONTH(I$7) and [ResultFor1]
(($D12*$E12)*25%

Scot
 
Top