worksheet

[Guest]

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?

 

[Don Guillett]

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.

 

[Guest]

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(D5>64,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

 

[NightHawk]

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.

 

[Sandy Mann]

Keith,

If I understand you correctly try in L5:

=IF(K5="","",IF(D5>64,K5*0.1,0))

and in M5:

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


HTH

Sandy