IF problem

classic Classic list List threaded Threaded
5 messages Options
bjlockie bjlockie
Reply | Threaded
Open this post in threaded view
|

IF problem

A            B     C     D    E
3/10/2020    15    KB    0    15

E1 contains this:
=IF(C3="KB",B3/1024,B3)
It displays 15

I tried:
=IF(C3="KB")
It displays TRUE

My formula works elsewhere.
Any ideas?



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Wade Smart Wade Smart
Reply | Threaded
Open this post in threaded view
|

Re: IF problem

When I format C as text or all it displays FALSE, not true.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 3:35 PM James <[hidden email]> wrote:

>
> A            B     C     D    E
> 3/10/2020    15    KB    0    15
>
> E1 contains this:
> =IF(C3="KB",B3/1024,B3)
> It displays 15
>
> I tried:
> =IF(C3="KB")
> It displays TRUE
>
> My formula works elsewhere.
> Any ideas?
>
>
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Wade Smart Wade Smart
Reply | Threaded
Open this post in threaded view
|

Re: IF problem

Make sure there is no spaces at all in the C column.
I removed all formatting and your formula result
is .014648438

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 3:42 PM Wade Smart <[hidden email]> wrote:

>
> When I format C as text or all it displays FALSE, not true.
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Sun, May 17, 2020 at 3:35 PM James <[hidden email]> wrote:
> >
> > A            B     C     D    E
> > 3/10/2020    15    KB    0    15
> >
> > E1 contains this:
> > =IF(C3="KB",B3/1024,B3)
> > It displays 15
> >
> > I tried:
> > =IF(C3="KB")
> > It displays TRUE
> >
> > My formula works elsewhere.
> > Any ideas?
> >
> >
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
bjlockie bjlockie
Reply | Threaded
Open this post in threaded view
|

Re: IF problem

On 2020-05-17 4:46 p.m., Wade Smart wrote:
> Make sure there is no spaces at all in the C column.
> I removed all formatting and your formula result
> is .014648438
>
Very weird, I just closed the file and reoponed it.
Maybe it needed to do a recalculation.



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Wade Smart Wade Smart
Reply | Threaded
Open this post in threaded view
|

Re: IF problem

If you make a change to your formula, click in the field
to get it to 'take'.

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Sun, May 17, 2020 at 7:46 PM James <[hidden email]> wrote:

>
> On 2020-05-17 4:46 p.m., Wade Smart wrote:
> > Make sure there is no spaces at all in the C column.
> > I removed all formatting and your formula result
> > is .014648438
> >
> Very weird, I just closed the file and reoponed it.
> Maybe it needed to do a recalculation.
>
>
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy