View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Programming Cells Programming Cells is offline
external usenet poster
 
Posts: 7
Default Help with Conditional Formula

I'm trying to create a conditional formula like:

=IF(OR(F2="Change",F2="New")*AND(G2="Auto CU")*AND(Q2=1),150,IF(Q2=2,200))

It works; however, if F2 is blank it still puts in the results either for
Q2=1 or Q2=2

How can I solve this. If there is no entry in F2 then I would want a
"Blank" result passed.

Many thanks for any help.