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