IF function help
 

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 function help
 

amyk wrote:
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"))

IF function help
 

Glenn wrote:
amyk wrote:
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)


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


If A1 could also have text:

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

IF function help
 

Glenn,

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

Amy

"Glenn" wrote:

Glenn wrote:
amyk wrote:
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)


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


If A1 could also have text:

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