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


"Kareinia" wrote:

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 :-(