0 instead of false

G

Guest

Hi all,

I put a formula in AR7 like this:

=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))

It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some
arguments. How can I get "0" instead of 'FALSE"?

Thanks & Regards,

Jaleel
 
R

Ron Rosenfeld

Hi all,

I put a formula in AR7 like this:

=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))

It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some
arguments. How can I get "0" instead of 'FALSE"?

Thanks & Regards,

Jaleel

Try:

=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0)

--ron
 
G

Guest

Thank you very much. It worked fine. Can you explain what is the *1 function?

Regards,

Jaleel
 
D

David Biddulph

You'd given the outcome for AO7=TRUE, but not for the alternative condition.
Another way would be =IF(AND(AO7=TRUE,AP7=TRUE),Z7,0)
 
G

Guest

Thanks a lot for all of you who replied with their wonderful formulas. I was
wondered at the shortest formulas of Papa and Rag.

Cheers!

Jaleel
 
J

JMay

What about using the "--" (I forget the $0.50 word/phrase for it) which
Converts TRUE/FALSE to 1/0,,??



=--IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))
 
R

Ron Rosenfeld

Thanks Ron. What was the shortcoming of my formula?

Regards,

Jaleel

=IF(AO7=TRUE,
IF(AP7=TRUE,Z7,0),???????)

Note that if your first condition is FALSE, you have not defined what to do
(that's where I have the ?'s). In that circumstance, the function will return
a FALSE.


--ron
 

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

Top