ExcelBanter - logical formula

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

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

- - logical formula (https://www.excelbanter.com/excel-worksheet-functions/207995-logical-formula.html)

Mike

logical formula

I have a logical formula that returns the word FALSE in the cell untill I
enter the correct parameters. Is there a way to remove the word FALSE from
the cell and still keep the formula?

Thanks

David Biddulph[_2_]

logical formula

=IF(cell_ref="","",your_formula)
--
David Biddulph

"mike" wrote in message
...
I have a logical formula that returns the word FALSE in the cell untill I
enter the correct parameters. Is there a way to remove the word FALSE from
the cell and still keep the formula?

Thanks

ShaneDevenshire

logical formula

Hi,

If the parameter is a number then you can use the shorter formula

=IF(A1,your_formula,"")

--
Thanks,
Shane Devenshire

"mike" wrote:

I have a logical formula that returns the word FALSE in the cell untill I
enter the correct parameters. Is there a way to remove the word FALSE from
the cell and still keep the formula?

Thanks

All times are GMT +1. The time now is 02:21 PM.