Oops, thanks! On Tuesday 19 April 2005 07:35, David Chapman wrote: > 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
