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
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
>
> =
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