Replies

You have quote marks around that part of the IF statement (treating it like text, not numbers)

=IF(G3=”RGW”,“+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2*1.5),2)“,+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

Should be:

=IF(G3=”RGW”,+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2*1.5),2),+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

You have quote marks around that part of the IF statement (treating it like text, not numbers)

=IF(G3=”RGW”,“+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2*1.5),2)“,+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

Should be:

=IF(G3=”RGW”,+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2*1.5),2),+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

I use the morefunc add-in that provides many usable features. One is “Filename” so you can use =FILENAME() to achieve this.
http://longre.free.fr/english/index.html%5B/url%5D

I use the morefunc add-in that provides many usable features. One is “Filename” so you can use =FILENAME() to achieve this.
http://longre.free.fr/english/index.html%5B/url%5D

FWIW, about two years we were looking at a real-world problem that we had narrowed down to 24 variables to look at correlation. Then we presented this to some statisticians. They wouldn’t even consider doing this on Excel or even Access. They used dedicated programs for dealing with that many variables (unfortunately, I can’t remember what programs they used).

FWIW, about two years we were looking at a real-world problem that we had narrowed down to 24 variables to look at correlation. Then we presented this to some statisticians. They wouldn’t even consider doing this on Excel or even Access. They used dedicated programs for dealing with that many variables (unfortunately, I can’t remember what programs they used).

Thanks, Steve. Another one to add to my arsenal.

Thanks, Steve. Another one to add to my arsenal.

Putting this macro into the Personal.xls allows it to be available for any worksheet. I also set up a button on the toolbar and link it to this macro. So, if I want to insert the origin (creation) date, I click on the button and this InputBox appears.
———————————————————-

Code:

Sub HeaderFooter()
Application.ScreenUpdating = False
myOrigin = InputBox("Enter origination date in MM/DD/YYYY format")

	ActiveSheet.PageSetup.PrintArea = ""
	With ActiveSheet.PageSetup
				.LeftFooter = "&9Data Date: " & myOrigin
		End With
Application.ScreenUpdating = True
End Sub

——————
Adjust to your appropriate needs.
Hope this helps
(I took out many other items for this example, so there may still be extra stuff. But you get the idea)

Putting this macro into the Personal.xls allows it to be available for any worksheet. I also set up a button on the toolbar and link it to this macro. So, if I want to insert the origin (creation) date, I click on the button and this InputBox appears.
———————————————————-

Code:

Sub HeaderFooter()
Application.ScreenUpdating = False
myOrigin = InputBox("Enter origination date in MM/DD/YYYY format")

	ActiveSheet.PageSetup.PrintArea = ""
	With ActiveSheet.PageSetup
				.LeftFooter = "&9Data Date: " & myOrigin
		End With
Application.ScreenUpdating = True
End Sub

——————
Adjust to your appropriate needs.
Hope this helps
(I took out many other items for this example, so there may still be extra stuff. But you get the idea)

=A2&B2

or

=CONCATENATE(A2,B2)

=A2&B2

or

=CONCATENATE(A2,B2)

I have found a free add-in from John Walkenbach does very nicely what you want.

http://j-walk.com/ss/dataform/cusomizing.htm%5B/url%5D

He extends the capability of Excel’s built in Data Form.

I have found a free add-in from John Walkenbach does very nicely what you want.

http://j-walk.com/ss/dataform/cusomizing.htm%5B/url%5D

He extends the capability of Excel’s built in Data Form.

I don’t have it with me right now, but I think that John Walkenbach does in his book MS Excel Power Programming with VBA. I can check tomorrow.