Formula Help
 

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!

--
Randy Street
Rancho Cucamonga, CA

Formula Help
 

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(A15,A1<11),"Phone call","In-Person
Mtg"))

Formula Help
 

Dave...YOU ROCK! Made some minor adjustments and it worked like a charm!
Thank you so very much!
--
Randy Street
Rancho Cucamonga, CA


"Dave O" wrote:

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(A15,A1<11),"Phone call","In-Person
Mtg"))

Formula Help
 

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

Formula Help
 

yes sir...I had caught that. Thanks again for your help with this. Have a
great weekend!
--
Randy Street
Rancho Cucamonga, CA


"Dave O" wrote:

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