When using a IF formula, one answer is false.
Can the word FALSE be changed to a zero?
Would appericate a "simple" example...
Thanks in advance
When using a IF formula, one answer is false.
Can the word FALSE be changed to a zero?
Would appericate a "simple" example...
Thanks in advance
Hi
Something like:
=IF(A2=6,"Yes",0)
Andy.
"At A Loss" <[email protected]> wrote in message
news:[email protected]...
> When using a IF formula, one answer is false.
> Can the word FALSE be changed to a zero?
> Would appericate a "simple" example...
> Thanks in advance
Without an example of the formula you're using or what you're trying to
accomplish, I can only guess...
Perhaps something like this:
=IF(A1=5,1000,0)
That formula test if the value of A1 is 5.
If TRUE, then return 1000
If FALSE, then return 0
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"At A Loss" wrote:
> When using a IF formula, one answer is false.
> Can the word FALSE be changed to a zero?
> Would appericate a "simple" example...
> Thanks in advance
>
You can convert FALSE to zero as follows:
=(1=2) will return FALSE
=(1=2)*1 will return zero
--
Gary's Student
"At A Loss" wrote:
> When using a IF formula, one answer is false.
> Can the word FALSE be changed to a zero?
> Would appericate a "simple" example...
> Thanks in advance
>
Ron, Here is my formula:
=IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
Hope the formula makes sense!!
Appericate your time and help on this.
On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
<[email protected]> wrote:
>Without an example of the formula you're using or what you're trying to
>accomplish, I can only guess...
>
>Perhaps something like this:
>
>=IF(A1=5,1000,0)
>That formula test if the value of A1 is 5.
>If TRUE, then return 1000
>If FALSE, then return 0
>
>Does that help?
>
>***********
>Regards,
>Ron
>
>XL2002, WinXP-Pro
>
>
>"At A Loss" wrote:
>
>> When using a IF formula, one answer is false.
>> Can the word FALSE be changed to a zero?
>> Would appericate a "simple" example...
>> Thanks in advance
>>
Here you go:
=IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"At A Loss" wrote:
> Ron, Here is my formula:
> =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
> Hope the formula makes sense!!
> Appericate your time and help on this.
>
> On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
> <[email protected]> wrote:
>
> >Without an example of the formula you're using or what you're trying to
> >accomplish, I can only guess...
> >
> >Perhaps something like this:
> >
> >=IF(A1=5,1000,0)
> >That formula test if the value of A1 is 5.
> >If TRUE, then return 1000
> >If FALSE, then return 0
> >
> >Does that help?
> >
> >***********
> >Regards,
> >Ron
> >
> >XL2002, WinXP-Pro
> >
> >
> >"At A Loss" wrote:
> >
> >> When using a IF formula, one answer is false.
> >> Can the word FALSE be changed to a zero?
> >> Would appericate a "simple" example...
> >> Thanks in advance
> >>
>
>
Alternatively, couldn't you just use this?
=IF(G2>=4,VLOOKUP(G2,J2:K8,2),0)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Ron Coderre" wrote:
> Here you go:
>
> =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "At A Loss" wrote:
>
> > Ron, Here is my formula:
> > =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
> > Hope the formula makes sense!!
> > Appericate your time and help on this.
> >
> > On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
> > <[email protected]> wrote:
> >
> > >Without an example of the formula you're using or what you're trying to
> > >accomplish, I can only guess...
> > >
> > >Perhaps something like this:
> > >
> > >=IF(A1=5,1000,0)
> > >That formula test if the value of A1 is 5.
> > >If TRUE, then return 1000
> > >If FALSE, then return 0
> > >
> > >Does that help?
> > >
> > >***********
> > >Regards,
> > >Ron
> > >
> > >XL2002, WinXP-Pro
> > >
> > >
> > >"At A Loss" wrote:
> > >
> > >> When using a IF formula, one answer is false.
> > >> Can the word FALSE be changed to a zero?
> > >> Would appericate a "simple" example...
> > >> Thanks in advance
> > >>
> >
> >
Ron, Used your formula. Appericate your time and help
Thanks!!
On Mon, 13 Mar 2006 08:27:06 -0800, Ron Coderre
<[email protected]> wrote:
>Alternatively, couldn't you just use this?
>
>=IF(G2>=4,VLOOKUP(G2,J2:K8,2),0)
>
>Does that help?
>
>***********
>Regards,
>Ron
>
>XL2002, WinXP-Pro
>
>
>"Ron Coderre" wrote:
>
>> Here you go:
>>
>> =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>> XL2002, WinXP-Pro
>>
>>
>> "At A Loss" wrote:
>>
>> > Ron, Here is my formula:
>> > =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
>> > Hope the formula makes sense!!
>> > Appericate your time and help on this.
>> >
>> > On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
>> > <[email protected]> wrote:
>> >
>> > >Without an example of the formula you're using or what you're trying to
>> > >accomplish, I can only guess...
>> > >
>> > >Perhaps something like this:
>> > >
>> > >=IF(A1=5,1000,0)
>> > >That formula test if the value of A1 is 5.
>> > >If TRUE, then return 1000
>> > >If FALSE, then return 0
>> > >
>> > >Does that help?
>> > >
>> > >***********
>> > >Regards,
>> > >Ron
>> > >
>> > >XL2002, WinXP-Pro
>> > >
>> > >
>> > >"At A Loss" wrote:
>> > >
>> > >> When using a IF formula, one answer is false.
>> > >> Can the word FALSE be changed to a zero?
>> > >> Would appericate a "simple" example...
>> > >> Thanks in advance
>> > >>
>> >
>> >
Ron, Used your formula. Appericate your time and help
Thanks!!
On Mon, 13 Mar 2006 08:27:06 -0800, Ron Coderre
<[email protected]> wrote:
>Alternatively, couldn't you just use this?
>
>=IF(G2>=4,VLOOKUP(G2,J2:K8,2),0)
>
>Does that help?
>
>***********
>Regards,
>Ron
>
>XL2002, WinXP-Pro
>
>
>"Ron Coderre" wrote:
>
>> Here you go:
>>
>> =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>> XL2002, WinXP-Pro
>>
>>
>> "At A Loss" wrote:
>>
>> > Ron, Here is my formula:
>> > =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
>> > Hope the formula makes sense!!
>> > Appericate your time and help on this.
>> >
>> > On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
>> > <[email protected]> wrote:
>> >
>> > >Without an example of the formula you're using or what you're trying to
>> > >accomplish, I can only guess...
>> > >
>> > >Perhaps something like this:
>> > >
>> > >=IF(A1=5,1000,0)
>> > >That formula test if the value of A1 is 5.
>> > >If TRUE, then return 1000
>> > >If FALSE, then return 0
>> > >
>> > >Does that help?
>> > >
>> > >***********
>> > >Regards,
>> > >Ron
>> > >
>> > >XL2002, WinXP-Pro
>> > >
>> > >
>> > >"At A Loss" wrote:
>> > >
>> > >> When using a IF formula, one answer is false.
>> > >> Can the word FALSE be changed to a zero?
>> > >> Would appericate a "simple" example...
>> > >> Thanks in advance
>> > >>
>> >
>> >
Ron, Used your formula. Appericate your time and help
Thanks!!
On Mon, 13 Mar 2006 08:27:06 -0800, Ron Coderre
<[email protected]> wrote:
>Alternatively, couldn't you just use this?
>
>=IF(G2>=4,VLOOKUP(G2,J2:K8,2),0)
>
>Does that help?
>
>***********
>Regards,
>Ron
>
>XL2002, WinXP-Pro
>
>
>"Ron Coderre" wrote:
>
>> Here you go:
>>
>> =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))
>>
>> Does that help?
>>
>> ***********
>> Regards,
>> Ron
>>
>> XL2002, WinXP-Pro
>>
>>
>> "At A Loss" wrote:
>>
>> > Ron, Here is my formula:
>> > =IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
>> > Hope the formula makes sense!!
>> > Appericate your time and help on this.
>> >
>> > On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
>> > <[email protected]> wrote:
>> >
>> > >Without an example of the formula you're using or what you're trying to
>> > >accomplish, I can only guess...
>> > >
>> > >Perhaps something like this:
>> > >
>> > >=IF(A1=5,1000,0)
>> > >That formula test if the value of A1 is 5.
>> > >If TRUE, then return 1000
>> > >If FALSE, then return 0
>> > >
>> > >Does that help?
>> > >
>> > >***********
>> > >Regards,
>> > >Ron
>> > >
>> > >XL2002, WinXP-Pro
>> > >
>> > >
>> > >"At A Loss" wrote:
>> > >
>> > >> When using a IF formula, one answer is false.
>> > >> Can the word FALSE be changed to a zero?
>> > >> Would appericate a "simple" example...
>> > >> Thanks in advance
>> > >>
>> >
>> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks