+ Reply to Thread
Results 1 to 38 of 38

Display issue

  1. #1
    Registered User
    Join Date
    08-07-2005
    Posts
    6

    Display issue

    I am creating a chart for tracking the result of 2 inputs. Here is an example:
    = (B6 * 1.082) - (C6 * 4.15) + 98.42

    On my chart 98.42 shows in all the cells of the column even though I have not entered anything in cells B6 and C6. Is there a way to have a blank chart until the inputs are entered?

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    how about

    = (B6 * 1.082)*IF(ISBLANK(C6),0,1) - (C6 * 4.15)*IF(ISBLANK(B6),0,1) + 98.42*IF(AND(NOT(ISBLANK(B6)), NOT(ISBLANK(C6))),1,0)

    the chart will then display all zeros until both b6 and c6 have entries
    not a professional, just trying to assist.....

  3. #3
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  4. #4
    Registered User
    Join Date
    08-07-2005
    Posts
    6

    Thanks Duane - Need Help with 1 more

    Thanks Duane. I tried to figure out what you did and apply it to
    =(E5/B5)*100 which show up as #DIV/0! on my chart but to no success.

    This is the last fault on my chart.

    Pete

    old dog trying to learn new tricks

  5. #5
    Registered User
    Join Date
    08-07-2005
    Posts
    6
    Thanks CLR as well

  6. #6
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  7. #7
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  8. #8
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  9. #9
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  10. #10
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  11. #11
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  12. #12
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  13. #13
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  14. #14
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  15. #15
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  16. #16
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  17. #17
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  18. #18
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  19. #19
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  20. #20
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  21. #21
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  22. #22
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  23. #23
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  24. #24
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  25. #25
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  26. #26
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  27. #27
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  28. #28
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  29. #29
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  30. #30
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  31. #31
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  32. #32
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  33. #33
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  34. #34
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  35. #35
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  36. #36
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  37. #37
    CLR
    Guest

    Re: Display issue

    =IF(AND(LEN(B6)>0,LEN(C6)>0), (B6 * 1.082) - (C6 * 4.15) + 98.42,"")

    Vaya con Dios,
    Chuck, CABGx3




    "bluenoser1946" <bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1tedia_1123423541.1811@excelforum-nospam.com...
    >
    > I am creating a chart for tracking the result of 2 inputs. Here is an
    > example:
    > = (B6 * 1.082) - (C6 * 4.15) + 98.42
    >
    > On my chart 98.42 shows in all the cells of the column even though I
    > have not entered anything in cells B6 and C6. Is there a way to have a
    > blank chart until the inputs are entered?
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




  38. #38
    CLR
    Guest

    Re: Display issue

    =
    "bluenoser1946" <bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com>
    wrote in message
    news:bluenoser1946.1telue_1123434370.9543@excelforum-nospam.com...
    >
    > Thanks CLR as well
    >
    >
    > --
    > bluenoser1946
    > ------------------------------------------------------------------------
    > bluenoser1946's Profile:

    http://www.excelforum.com/member.php...o&userid=26006
    > View this thread: http://www.excelforum.com/showthread...hreadid=393665
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1