Date and fee

[Dowjd]

I need a formula that when I enter the date in cell A1 a set fee appears in cell B1

A1 B1
August 16, 2012 $80.00

[ben_hensel]

What's the rule that generates the fee?

If it's a flat fee that pops up when there's a date entered, without assessing what the date actually is, but leaves B1 blank if A1 is blank:

B1 = IF(A1 <> "", fee_value, "")

Anyway, if fee_value is assessed based on date, you'll add some math, or maybe pump through some kind of lookup, if the fee is set based on the date falling in across a range or something.

[Dowjd]

Yes, a flat fee that will only show if a date is entered.

---------- Post added at 08:20 AM ---------- Previous post was at 08:15 AM ----------

Thanks Ben

That worked perfectly.

[gignz]

Hi,

don't know what you need it for but a simple thing you could do is =IF(A1<>0,80,"")
if you populate anything (also text) in A1 it would pop up $80 fees in B1

helps?
cheers