Re: [users] Formula in spread sheet

2005-04-19 Thread Chadley Wilson
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

Re: [users] Formula in spread sheet

2005-04-18 Thread David Chapman
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 > > =

[users] Formula in spread sheet

2005-04-18 Thread Chadley Wilson
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