IF function help

[amyk]

I think I need an IF function for this formula, but would like some help with
how to formulate it. This is what I want to do.

If column A is blank, then calculate Column B at $6.80. But, if column A
has a number in it, then calculate Column B at $6.00.

Can anyone help me put this formula together?

Many thanks!

 

[Glenn]

I think I need an IF function for this formula, but would like some help with
how to formulate it. This is what I want to do.

If column A is blank, then calculate Column B at $6.80. But, if column A
has a number in it, then calculate Column B at $6.00.

Can anyone help me put this formula together?

Many thanks!

If A1 is either blank or has a number:

=6+(A1=""*.8)


If A1 could also have text:

=IF(ISNUMBER(A1),6,IF(A1="",6.8,"A1 HAS TEXT"))

 

[Glenn]

If A1 is either blank or has a number:

=6+(A1=""*.8)

=6+((A1="")*0.8)


If A1 could also have text:

=IF(ISNUMBER(A1),6,IF(A1="",6.8,"A1 HAS TEXT"))

 

[amyk]

Glenn,

You are a lifesaver! Thank you very much for your help with this.

Amy