Forum Discussion
Excel Formula, combining two IF statements
I need to string together two IF statements, =IF(C7>=70, C7*0.5) and =IF(C7<=69, C7*0.65), please help
Perhaps
=IF( ISNUMBER(--C2)*ISNUMBER(--D2),
MIN(--C2, --D2),
IF( ISNUMBER(--C2), D2,
IF( ISNUMBER(--D2), C2,
IF(C2 > D2, D2, C2 ) ) ) )which returns
Thanks a lot Sergei. It works.
I need another favor. I need Column E to return like this in case of a blank cell (the last two rows):
C D E
11 2 2
2 11 2
a 2 a
2 a a
a b a
b a a
2 2
2 2
Thank you in advance.
pbasu92 , you are welcome
- This is Perfect!!!!! Thank you so much! 🙂