2 If-else statement in one cell

[silverskye787]

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,"")

 

[blackbox]

you have two different else statements

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

 

[silverskye787]

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]

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]

yes yes.. thanks alot.. it works fine...