# 2 If-else statement in one cell

#### silverskye787

##### Board Regular
how do i combine these two formula into one so as i can put it in one of the cell..

=IF(F8="","",F8)

=IF(B3>1,F8,"")

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### blackbox

##### Board Regular
you have two different else statements

what do you want to happen if F8 is not blank and B3 is less than 1?

#### silverskye787

##### Board Regular
if F8 is not blank, it will display on the text of F8 on F15,

if B3 is less than 1, F15 will not display anything out even if there is text on F8

#### blackbox

##### Board Regular
how's this

=IF(F8="","",IF(B3>1,F8,""))

i'm not clear on which cell has priority F8 or B3?

what if F8 is blank and B3 is greater than 1?
should F8 still be blank?

#### silverskye787

##### Board Regular
yes yes.. thanks alot.. it works fine...

Replies
4
Views
222
Replies
4
Views
317
Replies
1
Views
237
Replies
5
Views
567
Replies
7
Views
314

1,191,026
Messages
5,984,209
Members
439,878
Latest member
melodysc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back