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( IFERROR(--C2, C2) > IFERROR(--D2, D2), D2, C2)if I understood the logic correctly
Thank you Sergei. But the logic isn't accurate.
Column E should return like this:
C D E
11 2 2
2 11 2
a 2 a
2 a a
a b a
b a a
I need the function to return the lower number if C & D are both numeric and return the lower alpha if C & D are both alpha but when C is numeric & D is alpha or vice versa the function has to return the alpha.
Appreciate it.
Column E should return like this:
C D E
11 2 2
2 11 2
a 2 a
2 a a
a b a
b a a
I need the function to return the lower number if C & D are both numeric and return the lower alpha if C & D are both alpha but when C is numeric & D is alpha or vice versa the function has to return the alpha.
Appreciate it.
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.
SergeiBaklan
I tried working on it , modified the formula you used and managed to make it work.
The formula is this -=IF(IFERROR(-C2,D2)>IFERROR(-D2,C2),C2,D2)
Thank you.
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 a2 2
2 2
Thank you in advance.