Formula Help

R

Randy

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!
 
D

Dave O

You're up early!

Try this formula: I made an assumption that since these are dollar
values, they may not always be integers (whole dollars) so the formula
checks for less than $5, between $5 and $11, and over $11. Let me know
what you think.

=IF(A1<5,"Send letter",IF(AND(A1>5,A1<11),"Phone call","In-Person
Mtg"))
 
R

Randy

Dave...YOU ROCK! Made some minor adjustments and it worked like a charm!
Thank you so very much!
 
D

Dave O

Randy- Glad to help, but I notice I made some logic errors- maybe it's
too early for me too. The original formula I posted shows, for
instance, >5 and <5 but that doesn't account for =5. Hopefully you
caught and corrected that.

Dave O
 
R

Randy

yes sir...I had caught that. Thanks again for your help with this. Have a
great weekend!
 
Top