An yet another multiple IF statement in Excel -

An yet another multiple IF statement in Excel -

i'm having bit of pickle constructing multiple if statement. need (pseudo-code):

if c7<=150000 then c7*g8 or

if c7=>175000 and c7=>500000 then c7*g9 or

if c7=>525000 then c7*g10

... in 1 statement. final result must have € (euro symbol) right (being currency doesn't seem add together character).

pedro

here go, had utilize and when want know if value falls within specific range.

=if(c7<=150000;c7*g8;if(and(c7>=175000;c7<=500000);c7*g9;if(c7>=525000;c7*g10;"value out of range")))&" €"

excel