Hi - new here so please excuse if this is sa really silly question - I'm setting up a spreadsheet for our Local Showjumping Club - and essentially need a formula to do the following to calculate time penalties (0.25 penalty for every second over allowed time) G5 is the allowed time, T11 is the course time, and cell is where I am entering the formula/want the answer to go -
If T11 is greater than G5 than cell equals the difference x 0.25 or if T11 is less than G5 cell equals 0
I have teh first half of the formula worked out =IF(T11>G5,(T11-G5)*0.25) but am struggling on the second half!!
Any assistance would be fab!
Thanks in advance
Bex
Bookmarks