That would work if Daily would only come up on certain rolls...But if I put
in a charge code that will have an hourly rate, I would need that roll to be
okay...
It looks like this on my spread sheet
F37
G37 K37
classification #of Hours/Day Hours or day
Show Error
Dozer 10 Hours
Air Compressor 1 Day


I need it to show that I made a mistake if I put more then 1 in the #of
hours/day column, if the classificate is charge by daily rate.
I catch errors where I am keying that I put a 10 in where it should be 1 for
a daily rate...

I need to copy the condition down for several rolls that will change from
either an item that is based on hourly or items that will be based on daily.

If I put 10 on a classification that should be daily, I actually bill for 10
days...I was wanting a flag that would come up if I made that mistake.

I appreciate you helping me....I've tried to come up with it myself, but no
luck....

"Rick Rothstein (MVP - VB)" wrote:

I'm not sure if I have understood your question completely or not. Does this
do what you are looking for?

=IF(AND(G37="Daily",F371),"Error","OK")

Rick


"Kareinia" wrote in message
...
Can I please get additional help with the post that I posted earlier.
My first question was
If G37=daily, then F37 cannot be greater then 1. If it is greater then
one,
then an error message will show in K37.

I received a correct answer for that question..
=IF(AND(G37="Daily",F37<=1),"OK",Error")

I didn't think that some items will be based on hourly rates and I will
not
know what rolls will be that until the look up code picks up if it's a
daily
or hourly item that I'm billing. (I have a billing codes that are based on
different rates that are picked up on another sheet, based on the code
number
I use)

Can the formula have that if it's daily, that it will show the error if
over
1, and if hourly it will not show an error if it's over 1?
Lordy mercy, I'm having a hard time even saying what I need it to
show....I
hope someone will understand what I'm needing and respond....

Instead of lost in excel, I'm going to say dumb in excel.....
I would appreciate the help....
Thanks again.
Kareinia