formula got problem

[spilner]

hi,my formula is as below

=IF(Q17>S17,"TRUE",IF(S17Q17,"TRUE","FALSE")))

<q17,"true",if(s17><q17,"true",if(s17><q17,"true",if(s17><q17,"true",if(s17><q17,"true",if(s17>
the formula is working if in Q17 doesnt has a formula.

if Q17's value is extracted from formula example 30,then it not work.

if go to Q17 and change it manually to 30.then the formula work fine.

is there any problem?</q17,"true",if(s17></q17,"true",if(s17></q17,"true",if(s17></q17,"true",if(s17></q17,"true",if(s17></q17,"true",if(s17>

 

[Sektor]

I think you missed something here:
=IF(Q17>S17,"TRUE",IF(S17Q17,"TRUE","FALSE")))

 

[spilner]

i put the real formula i dont know why it turns like that.<q17,"true",if(s17>
</q17,"true",if(s17>

 

[spilner]

can u guys check in here?
http://pastebin.com/Hv3Geiyd

thats the formula,i dont know why i cant paste the formula in here.thanks

 

[nightcrawler23]

I dont know what the problem is going on , but you do have an extra close brackets there.

 

[spilner]

dont look at the first post formula,its wrong.i paste the right formula but it turns like that.

look here http://pastebin.com/Hv3Geiyd

 

[spilner]

theres somethin wrong with the Q17 formula.

the Q17 formula is

=IF(F28>2999,"30",IF(F28>999,"20",IF(F28>99,"10",IF(F28>29,"5","0"))))

is it right?

 

[Sektor]

Can't show answer 'cause forum deletes characters.

 

[spilner]

can u paste the answer in here
http://pastebin.com

 

[Marcelo Branco]

Hi,

When posting a formula with less than < put spaces around the < symbol, otherwise the forum software interprets as an html tag and erase everything to the right.

M.