IF function help

  • Thread starter Thread starter amyk
  • Start date Start date
A

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!
 
amyk said:
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!
Click to expand...


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