Figuring Golf Skins & Highlighting that cell

Originally Posted by davesexcel

1/2 a meg workbook is more than a sample, just supply a workbook with the worksheet in question, and show your desired results.

Sorry about that Dave. See attached. Thank you for your reply - Randy

Originally Posted by daddylonglegs

You can just put the original formula straight in a ROUND function, i.e.

=ROUND(IF(F8="B",(G8*$D$4/113),IF(F8="W",(G8*$E$4/113),IF(F8="G",(G8*$F$4/113)))),0)

or this formula will give the same result

=ROUND(G8*HLOOKUP(F8&"*",$D$3:$G$4,2,0)/113,0)

Thank you VERY much - that is what i was looking for. Thank you again!!

Originally Posted by daddylonglegs

You can just put the original formula straight in a ROUND function, i.e.

=ROUND(IF(F8="B",(G8*$D$4/113),IF(F8="W",(G8*$E$4/113),IF(F8="G",(G8*$F$4/113)))),0)

or this formula will give the same result

=ROUND(G8*HLOOKUP(F8&"*",$D$3:$G$4,2,0)/113,0)

Again, i think you. To push being a pest, can you tell me what the formula is for number of cells greater than 0? I do not want to know the value of those cells - i only want to know how many cells there are? I've attached the worksheet and wanted to insert that formula in cell AE4. the purpose is to tell me how many skins there are so that i can get a value of each skin based on number of players... etc.. thank you.

I haven't looked at your worksheet but it sounds like you want:

=COUNTIF(your range,">0")

Here is a copy of the sheet I used for our golf league. It will identify skins as well as identify a maximum of par plus 3 which we used for handicap purposes.

Hope you find some use for it.

Jim O

Originally Posted by Jogier505

Here is a copy of the sheet I used for our golf league. It will identify skins as well as identify a maximum of par plus 3 which we used for handicap purposes.

Hope you find some use for it.

Jim O

Thank you very much Jim - I think I can use this. Randy

Originally Posted by rwhite713

Thank you very much Jim - I think I can use this. Randy

Randy,

Thank for your response. I have had a great deal of help from this forum with Excel issues and as a relative newby it feels good to be able to give back something. Hope your project goes well.

Jim O

Thank you everyone for the response on the skins. I have one other question on ROUNDING. I have cells with IF formulas and i want the results to be rounded to the nearest whole number. It's in column I of the attached. Thank you for your help.