Thread: Formula Help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Randy Randy is offline
external usenet poster
 
Posts: 213
Default 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"))