Would like to have an "or" in an if, then statement

shebogen

New member
Joined
Dec 30, 2013
Messages
6
Reaction score
0
Points
0
I would like to have the formula below to allow for $B$32 or $C$32. Is this possible? Thank you in advance.


=IF($B$32=2,VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,2,TRUE)+VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,3,TRUE)*($B$29+$C$29-VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,1,"TRUE")),"")
 
Back
Top