See the following formula, where I have used multiple IFs. May this formula
give you a little hint about how to use multiple IFs with AND command.

=IF(AND(DAY(TODAY())=DAY(D4),MONTH(TODAY())=MONTH( D4)),"Happy Birthday"," ")

The above formula check the date store in column D4 with the system date AND
IF DAY and MONTH is equal then display "Happy Birthday" otherwise blank"

Let us know, if the information is useful to you.


"pdgood" wrote:


I'm trying to find a formula that adds to the pricing in certain
situations:
If B2=1 and C212 then I want to add .10*A2 If not 0
If B2=2 and C210 then I want to add .10*A2 If not 0
If B2=3 and C28 then I want to add .10*A2 If not 0
etc. through 12 possibilities for B2
Thanks.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=534656