Formula query

[Godders199]

Hi, i have written the following formula, all elements work correctly, apart the from last, which returns "true" instead of Medium.

=IF(CV6<>"",CV6,IF(CT6>=Macros!S$17,"Material",IF(CT6<=Macros!S$15,"low",IF(CT6>Macros!S$15,CT6<Macros!S$17,"medium"))))

I have tried making if or .. or if and but those dont work and running out of ideas.

Any help would be appreciated.

 

[NARAYANK991]

Hi ,

Your posted formula appears to be a truncated one ; can you post the complete formula ?

 

[Godders199]

Sorry

=IF(CV2<>"",CV2,IF(CT2>=Macros!S$17,"Material",IF(CT2<=Macros!S$15,"low",IF(CT2>Macros!S$15,CT2<Macros!S$17,"medium"))))

 

[NARAYANK991]

Hi ,

I think if you surround the entire formula with the CODE tags , it might display all of it.

 

[Godders199]

=if(cv2<>"",cv2,if(ct2>=marcos!ss$17,"material",if(ct2<=Marcos!s$15,"low",if(ct2>marcos!s$15,ct2<marcos!s$17,"medium"))))

just typed it rather than trying to copy.

 

[Godders199]

{"=IF(CV2<>"",CV2,IF(CT2>=Macros!S$17,"Material",IF(CT2<=Macros!S$15,"low",IF(CT2>Macros!S$15,CT2<Macros!S$17,"medium"))))"}

 

[Godders199]

can't get the hold forumla to stay, here is the bit that does not work.

IF(CT2>Macros!S$15,CT2<macros!s$17,"medium")
just returns true</macros!s$17,"medium")

 

[NARAYANK991]

Hi ,

So what do the cells CT2 and Macros!S15 ( the cell S15 in the Macros tab ) contain ?

 

[Godders199]

Thanks have worked it out with If and , i had left a "," out