Excel Formula

[pigeonguyuk]

Hi all anyone able to do me a formula for the following

what i want is the following

if cell A1 is 0-14 then (output cell) = £0
if cell A1 is 15-19 then (output cell) = £125
if cell A1 is 19-24 then (output cell) = £200
if cell A1 is 25+ then (output cell) = £125


would need all combined within the one formula if possible?

 

[pigeonguyuk]

all sorted got the formula below to work nicely. Just needed to reverse the order from highest to lowest


=IF(O13>=25,250,IF(O13>=20,200,IF(O13>=15,125,IF(O13>0,0,0))))