Circular Reference

Ralph M · May 14th, 2002, 11:17 AM

I would like to have a cell, that when I enter a number into it, it automatically converts it to 1.5 times. Like time and a half. I know there are functions in Excel that require a circular reference but I'm not sure how to do this. Can it be done?

Asala42 · May 14th, 2002, 11:54 AM

Greetings,

I'm not sure exactly why you want an intentional circular reference for this, (maybe you can give more detail).

Can you get away with something like the following:

=IF(A8<40,HourRate*A8,HourRate*(40+1.5*(A8-40)))

Where A8 = total hours worked for the week.

Adam

Ralph M · May 14th, 2002, 03:20 PM

I want to be able to type in 12 hrs and have it record 18 hrs in the same cell that I typed the 12 in. So I could type in 12 and it would show 18. I don't want to add a column because I want to see the whole spreadsheet on one page.

DZarlengo · May 14th, 2002, 05:51 PM

Do you want to keep your original value? If so, insert a new column for the original numbers and hide it when you no longer want to see the numbers. If you don't care about the original value (a very questionable and not-recommended practice) write a macro that multiplies the "current cell" by 1.5 - you can assign it to a shortcut key, a new toolbar button, or a new menu command.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 11:17 AM	#1
Ralph M Board Regular Join Date: Apr 2002 Posts: 436	I would like to have a cell, that when I enter a number into it, it automatically converts it to 1.5 times. Like time and a half. I know there are functions in Excel that require a circular reference but I'm not sure how to do this. Can it be done?

May 14th, 2002, 11:54 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Greetings, I'm not sure exactly why you want an intentional circular reference for this, (maybe you can give more detail). Can you get away with something like the following: =IF(A8<40,HourRateA8,HourRate(40+1.5*(A8-40))) Where A8 = total hours worked for the week. Adam

May 14th, 2002, 03:20 PM	#3
Ralph M Board Regular Join Date: Apr 2002 Posts: 436	I want to be able to type in 12 hrs and have it record 18 hrs in the same cell that I typed the 12 in. So I could type in 12 and it would show 18. I don't want to add a column because I want to see the whole spreadsheet on one page.

May 14th, 2002, 05:51 PM	#4
DZarlengo Board Regular Join Date: May 2002 Posts: 63	Do you want to keep your original value? If so, insert a new column for the original numbers and hide it when you no longer want to see the numbers. If you don't care about the original value (a very questionable and not-recommended practice) write a macro that multiplies the "current cell" by 1.5 - you can assign it to a shortcut key, a new toolbar button, or a new menu command.