Display issue

**bluenoser1946** · 08-07-2005, 09:23 AM

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?

**duane** · 08-07-2005, 11:05 AM

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

CLR · 08-07-2005, 12:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

**bluenoser1946** · 08-07-2005, 12:33 PM

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

**bluenoser1946** · 08-07-2005, 12:50 PM

Thanks CLR as well

CLR · 08-07-2005, 02:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-05-2005, 10:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-05-2005, 10:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-05-2005, 11:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-05-2005, 11:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 12:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 12:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 01:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 01:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 02:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 02:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 03:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 03:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 04:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 04:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 06:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 06:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 07:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 07:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 10:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 10:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 11:05 AM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 11:05 AM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 12:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 12:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 02:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 02:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 03:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 03:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 06:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 06:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 07:05 PM

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

Vaya con Dios,
Chuck, CABGx3

"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

CLR · 09-06-2005, 07:05 PM

=
"bluenoser1946" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

Display issue

LinkBack

Thread Tools

Rate This Thread

Display

Display issue

Re: Display issue

Thanks Duane - Need Help with 1 more

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Re: Display issue

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions