[Jtuds]

I am using a formula to perform a repetitive calculation and have protected the sheet so people can't edit the formula. I want to set it so that when people close the file, the values they entered are not saved with it....in fact, I don't want the save option to show up at all.

So if the formula is =sum(c1+c3)/12, I want c1, c3, and the answer cell to go blank upon closing the file.

Can anyone tell me how to do this?

[MadBacker Prime]

Just make it read only-

They can still use the formula you entered but would have to save the file as their own to keep the changes.

It's under the save settings when you click save as.



Is this 2007??

[MBGreen]

Originally Posted by Jtuds

I am using a formula to perform a repetitive calculation and have protected the sheet so people can't edit the formula. I want to set it so that when people close the file, the values they entered are not saved with it....in fact, I don't want the save option to show up at all.

So if the formula is =sum(c1+c3)/12, I want c1, c3, and the answer cell to go blank upon closing the file.

Can anyone tell me how to do this?

There's an option under the tools menu called macros...select it...and open up the Visual Basic Editor.

If you know how to code in Visual Basic...this will be an easy fix.....If you PM me what you want done in full detail...I could probably write the script for you.

[Jtuds]

Yeah unfortunately I can't write macros. What I am doing right now would be so much easier if I could...

ok MB I might PM you....sort of complex though...I'd have to figure out how to explain it.

It's in 2003.

[MBGreen]

Originally Posted by Jtuds

Yeah unfortunately I can't write macros. What I am doing right now would be so much easier if I could...

ok MB I might PM you....sort of complex though...I'd have to figure out how to explain it.

It's in 2003.

I'll do what I can to help.

I'm using 2003 as well.

[IATA]

[MBGreen]

^ gross...yet...funny.


lawl.

[IATA]

Wait, nevermind. That comment could be construed wrong...

[MBGreen]

Originally Posted by IATA

Wait, nevermind. That comment could be construed wrong...

what you do in your spare time is your business, man.....doesn't mean the rest of us can't enjoy a hearty laugh over it.

At least, now we know why all those pics of hot broads were considered to be "butterfaces" in your opinion........

[Jtuds]

Got it sorted out now....and learned about IF statements

[MBGreen]

Originally Posted by Jtuds

Got it sorted out now....and learned about IF statements

Yep...If statements are a programmer's best friend.

[fenwyr]

Originally Posted by MBGreen

Yep...If statements are a programmer's best friend.

Especially when combined with other if statements. The most essential Excel formula for me over the last couple years:

{=sum(if(A=B,C,0)*if(X=Y,Z,0))}

Well, that and VLOOKUP.

[Jtuds]

New request.

In column G I have =$f2-$e2

I want to drag that formula down the page but I dont want to have a 0 in column G for every single row. I just want the numbers to appear in each row of column G as info gets entered into columns F and E as we go down the worksheet. So basically, I don't want anything to populate in column G unless there's data in the corresponding cell in column F.

I think it is an IF statement but I cant rememeber how to do it.

I used to know how to make all this stuff easier and enjoyed usng these formulas, now I can't remember any of this stuff

[nyscene911]

Try this
=IF(And(Not($f2=0), Not($g2=0)), $f2-$e2, "")

[LeonNYJ]

Or you could also simply use:

=If($F2="","",$F2-$E2)

[fenwyr]

Originally Posted by nyscene911

Try this
=IF(And(Not($f2=0), Not($g2=0)), $f2-$e2, "")

Originally Posted by LeonNYJ

Or you could also simply use:

=If($F2="","",$F2-$E2)

The first is more flashy, but the second is easier. Both work just as well, thouh I think you need "" instead of 0 in the first one.