Excel Formula??

[benjibeef]

What Excel formula do I use if I want to say...
(B5=345 if C3<801 also B5=545 if C3<1601 also B5=742 if C3<7501) and so on.
I'm sure there's a perfectly simple explanation but allas I cannot work it out for myself.

[Wak]

Not sure about this but I would have thought that the IF should be first rather than the instruction ? Possibly something like this.
IF (C3<801 then B5=345 otherwise if C3<1601 then B5=545 otherwise if C3<7501 then B5=742)
Just a thought!

[rojash]

You don't need to say B5= anything, because you put the formula in B5:
=IF(C3<801,345,IF(C3<1601,545,IF(C3<7501,742,
0)))

Which reads as:
If C3<801 then 345, ELSE if C3<1601 then 545, else if C3<7501 then 742, else 0