Shouldn't it be... =IF((N25*N26*21,67)>=1000;1000;N25*N26*21,67)
You originally had a string "1000" in the IF formula. Dave My OpenOffice Calc Website http://www.openofficetips.com On 4/18/05, Chadley Wilson <[EMAIL PROTECTED]> wrote: > > Greetings > > In cells G23 i Have this formula > > =IF((N25*N26*21,67)>=1000;"1000";N25*N26*21,67) > > And in cell G33 I have this formula, > > =G23+10 > > When the condition is true for the value to be 1000 then it ignores the value > > eg: G23 is equal to 1000 > > G33 = 10 instead of 1010 > > Why?????? > > I am stumped > > TIA > Chad > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
