ExcelBanter - IF multiple arguments

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF multiple arguments (https://www.excelbanter.com/excel-worksheet-functions/180531-if-multiple-arguments.html)

IF multiple arguments

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

Dave Peterson

IF multiple arguments

David Biddulph[_2_]

IF multiple arguments

=IF(B1="","",IF(B150,2,1))
--
David Biddulph

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

All times are GMT +1. The time now is 09:13 AM.