IF statement help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TammyS - 28 Jun 2006 22:45 GMT

I have a master workbook that I SAVE AS each day as a new workbook. The
person who fills in for me didn't create a new workbook and made a big
mess--I'm still finding formulas and cells that were changed. I formatted
the date cell to be bright pink if it remains empty, but I would like a "SAVE
AS" message to appear if anything has been typed in cell R110, R119, R128, or
R137. The date cell is S163. I have tried various formulas but got error
messages or not the result I wanted. I would appreciate any help or a better
suggestion to deal with problem. Thanks.

Reply to this Message

JMB - 29 Jun 2006 02:26 GMT

File/Save As/Tools/General Options - put in a password to modify. Without a
password the orginal file will be read only and the open file will have to be
saved as a copy using Save As. I believe excel removes the password on the
copy, so another user could open that file (the copy) and make changes, but
your original should remain intact.

> I have a master workbook that I SAVE AS each day as a new workbook. The
> person who fills in for me didn't create a new workbook and made a big
[quoted text clipped - 4 lines]
> messages or not the result I wanted. I would appreciate any help or a better
> suggestion to deal with problem. Thanks.

Reply to this Message

TammyS - 29 Jun 2006 14:25 GMT

It's already password protected. I was on vacation, she was filling in for
me and on the second or third day she forgot to save the master as a new
workbook for that particular day until she was practically done with the
process. I was hoping for a message of some kind to pop up before she got
very far without creating a new workbook. Thanks anyway.

> File/Save As/Tools/General Options - put in a password to modify. Without a
> password the orginal file will be read only and the open file will have to be
[quoted text clipped - 10 lines]
> > messages or not the result I wanted. I would appreciate any help or a better
> > suggestion to deal with problem. Thanks.

Reply to this Message

JMB - 30 Jun 2006 00:14 GMT

=IF(OR(R110<>"", R119<>"", R128<>"", R137<>""),"SAVE AS","")

> It's already password protected. I was on vacation, she was filling in for
> me and on the second or third day she forgot to save the master as a new
[quoted text clipped - 16 lines]
> > > messages or not the result I wanted. I would appreciate any help or a better
> > > suggestion to deal with problem. Thanks.

Reply to this Message

TammyS - 30 Jun 2006 13:40 GMT

=IF(S163<=0,"ENTER DATE, SAVE AS","")
This is what I came up with as a temporary fix before I posted here. Your
formula, although I don't understand it, gave me the idea to post a revision
of my original formula in a blank spot by the name of each shift, so the
message would appear in the immediate line of sight. Thanks for your help.

> =IF(OR(R110<>"", R119<>"", R128<>"", R137<>""),"SAVE AS","")
>
[quoted text clipped - 19 lines]
> > > > messages or not the result I wanted. I would appreciate any help or a better
> > > > suggestion to deal with problem. Thanks.

Reply to this Message

JMB - 30 Jun 2006 21:46 GMT

I'm glad it gave you some ideas. The OR function will return TRUE if any of
the conditions inside the ( ) are true, otherwise FALSE. The entire OR
statement is the first argument for the IF function. There is a great deal
of flexibility in nesting functions in this manner, they just cannot exceed 7
levels and must return the correct data type (in this case it has to be
TRUE/FALSE since that is what is expected for the first argument of the IF
function).

OR(R110<>"", R119<>"", R128<>"", R137<>"") evaluates to TRUE/FALSE

S163<=0 also will evaluate to TRUE/FALSE. As long as the result is boolean
(TRUE or FALSE) it does not matter if it is the result of a conditional
statement (using =, <, >, or <> operators) or is just the return value of
another function (such as OR, AND, the various IS functions, etc).

> =IF(S163<=0,"ENTER DATE, SAVE AS","")
> This is what I came up with as a temporary fix before I posted here. Your
[quoted text clipped - 25 lines]
> > > > > messages or not the result I wanted. I would appreciate any help or a better
> > > > > suggestion to deal with problem. Thanks.

Reply to this Message

TammyS - 30 Jun 2006 23:27 GMT

Thanks for the explanation. I enjoy the challenge of putting together a
formula that actually works but it can be VERY frustrating.

> I'm glad it gave you some ideas. The OR function will return TRUE if any of
> the conditions inside the ( ) are true, otherwise FALSE. The entire OR
[quoted text clipped - 40 lines]
> > > > > > messages or not the result I wanted. I would appreciate any help or a better
> > > > > > suggestion to deal with problem. Thanks.

Reply to this Message