Forum Discussion

Copper Contributor

Apr 20, 2018

Solved

Formula help

I need help creating the formula for cell F3. Stating that if cell D3 is as follows: 1-5=0 6-8=3 9-11=4 12-14=6 15-17=8 18-19=10 20-21=12 22+=15 I'm sure its a simple formula but I have no i...

Excel Online

Formulas & Functions

Haytham Amairah
Apr 27, 2018
OK, I've updated the formula in the workbook to lookup the accident number instead of the accident type.

Regards
SPEED VIOLATION TRACKER Update #4.xlsx54 KB

Jeremy Wilkerson

Copper Contributor

Apr 26, 2018

Thanks for all your help with this Sir. Is there any way you can set it up so that under Accident I can put 1-20 depending on the accident/incident and then those points would still go in the points assessed column, without doing anything with the speed limit/actual speed columns? Thanks

SPEED VIOLATION TRACKER Update #3.xlsx54 KB

Haytham Amairah

Silver Contributor

Apr 27, 2018

OK, I've updated the formula in the workbook to lookup the accident number instead of the accident type.

Regards

SPEED VIOLATION TRACKER Update #4.xlsx54 KB

Jeremy Wilkerson
Copper Contributor
Apr 27, 2018
You are the man!! I wish I was smart enough to know all that, but at least I was smart enough and ask for help, and got such a great helper. Thanks a lot, again.