Having trouble with if statements with 3 criterias

[vba_newbie83]

Hi,

This maybe very easy to solve but i have spent a good 1hour on this with no luck
I have a rule which i need to apply to give me 3 results. I need a if formula to return 3 results if the client money changes

Rules, which i need the cell to return if i use an IF Statement
$0 - >=$100 = return the value of what the client has in holdings
Between $100m and >= $200m = return value of $100m only
>$200m+ = cell returns 0

Example: Client holds $99m
If statement will return the same amount client holds

Example: Client holds $150m
If statement will return $100m

Example: Client holds $250m
If statement will return 0

Hope someone can assist

[samba_ravi]

=IF(A1<=100,A1,IF(A1<=200,100,0))
try this formula (assuming that you have data in "A1")

[vba_newbie83]

thank you, this worked. so easy now when i look at the formula. i couldn't get my head around it

thank you so much

[samba_ravi]

you are welcome