logical formula

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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
 
Hi,

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

=IF(A1,your_formula,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find certain text in a cell 3
Logical formatting for multiple values 1
How do i trouble shoot an IF function 2
MATCH not working in IF statement 6
Searching the formula (not the value) for a text string 1
Numerical value of logicals 4
formula shows false 6
How do I write an IF function using dates? 2

Back
Top