Thread: Simple AND formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Simple AND formula
=IF(AND(C2="PARENT", B2="B"),90)

.... and if false?

=IF(AND(C2="PARENT", B2="B"),90,???)

HTH

"digital21st" wrote:


Hi Guys

I know this is simple but can somebody tell me how the below formula
should be written

=IF(C2="PARENT" AND B2="B",90)

I know the "AND" part in the middle is incorrect

Thanks inadvance

Digital


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=562765


Reply With QuoteReply With Quote