Condition Formula

[Kareinia]

Could someone please help me with a formula...I'm not smart with it comes to
excel....I have a spreadsheet that I'm having issues with that I'm not
catching the errors.
Can a condition be put in for this?

If G37=Daily, then F37 cannot be greater then 1? If it is greater then one,
then an error message will show in K37?

signed: lost in excel :-(

 

[Teethless mama]

In K37: =IF(AND(G37="Daily",F37<=1),"OK","Error")

 

[Kareinia]

Thank you so much!!! Have a wonderful day....

In K37: =IF(AND(G37="Daily",F37<=1),"OK","Error")

 

[Kareinia]

In K37: =IF(AND(G37="Daily",F37<=1),"OK","Error")

 

[Kareinia]

Oh no, I have a problem...
I didn't think about what would happen if G37 = hourly...If it's okay for it
to be over 1.... Is it possible to have that in this formula?

Maybe it would help if I explain what my spread sheet does...I use it to
bill with...If I put in 10 on the daily rate, then I bill for 10 days which
should only be billed 1 day at a time. If the price is based on hourly rate,
then normaly it will be 10.... I'm trying to fix it so I won't bill the
customer wrong....I have in the past, and it's hard for me to catch if I'm
really busy...I'm sorry for the bother again...I really appreciate your help.