IF Statements (Beginner)

Hello guys, here's a little background. This is for an insurance company (hypothetically)
• $10 for a sports vehicle
• $15 for a red vehicle
• $20 for each accident in the past five years
• $5 for each accident historically not in the past five years

I am trying to calculate the Premium Modification
is there a way to get the IF Statement to return "0" rather than false if none of the statements apply?

This is what I have currently
=IF(H3="Sports",20,IF(I3="Red",15,IF(G3>0,G3*20,IF(F3>0,F3*5))))
When I try to add a 0 after the 20, it says I have too many arguments.

Also, here is a picture of my sheet.
https://gyazo.com/bc4997cff1c1c0a48e6248b2cdd1fdf3

Another issue:
Im showing the formula for R17, the result is 60, however the expected result should be G17*20 = 60, and then F17*5 = 35 so the total should be 95. Im thinking that Or is not the right solution here, maybe XOR? This is just counting the first condition it comes to.

Hi,

can you attached some excel file for that.

Imran.

Paws.xlsx

Here you go! Thanks for the help.

Hi,

Please find attached excel file.

Imran.

Mdimran, thank you for your work, but however, The first premium ( R3 ) should show as 25, this is because 3 Accidents Total = 3*5 = 15 and Sports Vehicle = 10, so 25.

Hi,

I am some modification in formula i hope this will help you.

Imran.

Added Rep! Thanks

Hi,

if you have satisfied with my answer please add reputation. Click on Add Reputation button on your left bottom.

Imran.