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

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

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

"Teethless mama" wrote:

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

"Teethless mama" wrote:

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

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.

"Teethless mama" wrote:

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