0 instead of false

[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

 

[Guest]

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

 

[Jim Cone]

=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Jaleel" <[email protected]>
wrote in message
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

 

[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

 

[Guest]

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

Regards,

Jaleel

 

[Ragdyer]

Try this:

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

Or this:

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

 

[Guest]

Enclose everything in the N worksheet function:
=N(IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)))

 

[Guest]

Thanks Jim. It also worked. What was the shortcoming of my formula?

Regards,

Jaleel

 

[Guest]

Thanks Ron. What was the shortcoming of my formula?

Regards,

Jaleel

 

[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)

 

[Guest]

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

or if Z7 is always a number

=AO7 * AP7 * Z7

 

[Guest]

It is just a way to convert TRUE/FALSE to 1/0

 

[Guest]

Thanks David for your explanation.

Regards,

Jaleel

 

[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

 

[Guest]

your formula can be written as
N(AO7*AP7*Z7)

 

[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))

 

[SteveW]

Surely it was the missing else condition that caused Flase in the first
place

Steve

 

[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