greater than function

[amy]

I'm having a problem with a function. I have it set up
like this =IF((B3)>200,1*A3,IF((B3)>100,3*A3,IF((B3)
<101,5*A3))) and when I hit enter it give me #VALUE!,
please let me know what i did wrong.

Thanks bunches
Amy

 

[svein]

ALEX is incorrect: If functions are logical: >200 takes all over 200, then >100 takes 200 to 100,00001, so the formula is good as: =IF((B3)>200;1*A3;IF((B3)>100;3*A3;5*A3))

 

[Harlan Grove]

ALEX is incorrect: If functions are logical: >200 takes all over 200, then
IF((B3)>100;3*A3;5*A3))

Which you should have done first. The ..IF(x>100,...,IF(x<101,...)) was
confusing if innocuous. Finally, if you want to reply in English language
newsgroups in order to help OPs posting in English, you should either use
standard English language conventions, e.g., 1.2 = 1 + 2/10 and IF(a,b,c), not
1,2 and IF(a;b;c). If an OP posts using continental European conventions, then
responding in kind is OK, but when an OP uses standard English language
conventions, either use those conventions in your reply or just don't reply.

Thr's n gd rsn nt 2 d ths thr thn cltrl rrgnc. F tht's wht mtvts u, thr r wys f
mkng t vry dffclt 4 u t fllw th rspnss.