View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amyk amyk is offline
external usenet poster
 
Posts: 2
Default 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!