Thread: IF multiple arguments
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default IF multiple arguments
=if(b1="","",if(b150,2,1))


wrote:

I have =IF(B150,2,1) in cell A1 How an a get a blank value if B1 is blank
in A1

--

Dave Peterson
Reply With QuoteReply With Quote