K
Keith
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?
problem that I am having with my formulas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
to explain your problem with examples and desired results with examples.
Copy/paste to here.
K
Keith
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
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
N
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.
#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.
S
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
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