worksheet
 

Is there some way that I can send a copy of my worksheet so you can see the
problem that I am having with my formulas?

We prefer that you NOT do that. In fact, many will not bother to look. Try
to explain your problem with examples and desired results with examples.
Copy/paste to here.

--
Don Guillett
SalesAid Software

"Keith" wrote in message
...
Is there some way that I can send a copy of my worksheet so you can see
the
problem that I am having with my formulas?

Column G H I J K L
M
row 5 9:00 AM 9:15 AM 15.00 $1.05 $15.75 $1.58 $25.00
row 6 $- #VALUE!
row 7
$- #VALUE!

That is a portion of my spreadsheet
the formula in L5 is =IF(D564,K5*0.1,0) and in M5 is =IF(K5<25,25,K5-L5)
both of these formulas work fine as long as the referenced cells have data.
What I am having trouble with and need help is as you can rows that have no
data entered I get in column L $- which I want to stay blank until there is
data to process and in column M #VALUE! which I also want blank if there is
no data to process.

If You can help I will appreciate it.
Thanks,
Keith



"Don Guillett" wrote:

We prefer that you NOT do that. In fact, many will not bother to look. Try
to explain your problem with examples and desired results with examples.
Copy/paste to here.

--
Don Guillett
SalesAid Software

"Keith" wrote in message
...
Is there some way that I can send a copy of my worksheet so you can see
the
problem that I am having with my formulas?

Look at using a IF(ISERROR construction for your formula.

#Value, #N/A and #DIV/0 errors can be made to look anyway you want if
you embed your formula inside an error checking routine.

=IF(ISERROR(Formula),Result if error which can be anything from 0 to
"",(Formula))

Excel Help has a lot more on this.

Keith,

If I understand you correctly try in L5:

=IF(K5="","",IF(D564,K5*0.1,0))

and in M5:

=IF(K5="","",IF(K5<25,25,K5-L5))


HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Keith" wrote in message
...
Column G H I J K
L
M
row 5 9:00 AM 9:15 AM 15.00 $1.05 $15.75 $1.58 $25.00
row 6 $- #VALUE!
row 7
$- #VALUE!

That is a portion of my spreadsheet
the formula in L5 is =IF(D564,K5*0.1,0) and in M5 is
=IF(K5<25,25,K5-L5)
both of these formulas work fine as long as the referenced cells have
data.
What I am having trouble with and need help is as you can rows that have
no
data entered I get in column L $- which I want to stay blank until there
is
data to process and in column M #VALUE! which I also want blank if there
is
no data to process.

If You can help I will appreciate it.
Thanks,
Keith



"Don Guillett" wrote:

We prefer that you NOT do that. In fact, many will not bother to look.
Try
to explain your problem with examples and desired results with examples.
Copy/paste to here.

--
Don Guillett
SalesAid Software

"Keith" wrote in message
...
Is there some way that I can send a copy of my worksheet so you can
see
the
problem that I am having with my formulas?