Re: What function do I use to return a certain value for specific text
- From: "Bondi" <mbondorff@xxxxxxxxxxx>
- Date: 29 Jun 2006 15:32:35 -0700
marjoryann wrote:
e.g. if 5-2100 is entered into A1 then A2 should automatically = $31.00, if
5-6100 is entered into A1 then A2 should automatically = $36.00.
Hi,
Is there any connection between text and amount?
Regards,
Bondi
.
- Prev by Date: Re: Can I use "In" in an "If" statement?
- Next by Date: Re: How to use the $ to do global func> =ave($1:$1) more details?
- Previous by thread: Standby in Excel
- Next by thread: Re: using a number to select cell location
- Index(es):