Replace with IF function

[Brad1125]

Hey Guys! I have attached the workbook that I am working on for reference. I have two worksheets in this workbook to keep basketball stats. One worksheet is called Game (Sheet 1) and the other is called Game Records (Sheet 2). On Sheet 1, as I complete each game I will manually input those figures (minutes, fgs, 3pt fgs, etc). For example if my minutes played in a basketball were 50 then that will go under the Game row, column Minutes played. What I want to do is write a formula (for minutes played) in Sheet 2 that takes that value (50) and says IF that value is greater then the value in x cell then use that value if not, use x cell. You can see in Sheet 2 that cell B24 has that formula. The problem is it's reference cell, B:33 (which I will be hiding) has to be manually updated. So I want B:33 to read the minutes played (for a game) in sheet 1 and if that value is greater then the value that is currently in B:33 then replace it. Problem is, I keep running into circular references (rightfully so), can anyone help me with this? Thanks!

[mikeTRON]

it sounds like you just want the MAX of the two, in which case you can use for cell B24:

Please Login or Register  to view this content.

[Brad1125]

it sounds like you just want the MAX of the two, in which case you can use for cell B24:

Please Login or Register  to view this content.

Thanks for your reply! The MAX function still requires me to manually enter a value into B33. Im not sure of any way around that though. What im trying to accomplish is, a formula that reads the stat cells on sheet 1 and inputs them into the game records tab. If the stats on sheet 1 exceed those on sheet 2 then replace. But i only want to manually enter the sheet 1 values. The sheet 2 values should be replaced (via a formula) once the sheet 1 values exceed them.

[mikeTRON]

I guess I still dont understand your sample. I suggest providing sample examples in there as well, with real data and a hand typed "solution" so we can see what you are trying to do.

[Brad1125]

I've reattached the workbook for reference. You'll see on the Game worksheet (Sheet 1) that I have filled in minutes calculations (12 per quarter and 5 for overtime) totaling 53 minutes which calculates on Sheet 1, Cell B17. I would go ahead and manually input the rest of data on this sheet as mentioned in my original post. Let's say that my first game out I end up playing 53 minutes. That value would be copied from the Game page to the Game Records page (as you see in the workbook). If I then play a second game (all of my Sheet 1 values are erased so I can start a new game) and I exceed 53 minutes, I want the new greater value to replace the old 53 value, and so on and so on. The MAX function would work IF I manually entered the new personal record which exceeds 53 minutes but I'd like for excel to take the initial 53 minutes from the first game then compare that value to my second game and if the second game exceeds the first then replace. Like keep a personal record book of sorts.

[mikeTRON]

Formulas can't replace raw data.

It sounds like you need a THIRD sheet that is just a report to show the max and such. Otherwise what you are trying to do is not possible with formulas.

[Brad1125]

Formulas can't replace raw data.

It sounds like you need a THIRD sheet that is just a report to show the max and such. Otherwise what you are trying to do is not possible with formulas.

Okay, thank you very much!