Formula Help

[Guest]

I know this is probably easy but my brain is not function too weel this
morning. I nneed some assistance with a formula...

I have a speadsheet that I need to input a value in one cell based on a
value entered from another cell...

Example:
if cell "A" = $1.00-$5.00 cell "B" should state "Send Letter"
if cell "A" = $6.00-$10.00 cell "B" should state "Phone Call"
if cell "A" = $11.00-Over cell "B" should state "In-Person Meeting"

If anyone has any ideas I would be forever grateful. I thank you in advance
for any assistance you can provide.

Have a great day!

 

[Douglas J. Steele]

Your use of "cells" implies you're talking about Excel. This newsgroup is
for questions about using macros in Access, the database product that's part
of Office Professional.

You'd probably be better off asking in a newsgroup related to Excel.