Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Funkcija IF (excel, open office)

94 views
Skip to first unread message

Antonio Q

unread,
Jan 5, 2011, 3:50:59 PM1/5/11
to
Pozdrav,

uporno pokusavam i nikako ne uspjevam napraviti visestruku IF funkciju u
jednoj celiji! Iako postupam prema onome u Help uporno mi izbacuje da
funkcija ima gresku!

dakle primjer

A1 je broj koji ako je

=0 ispisuje nula
>0 ispisuje +
<0 ispisuje -

moja formula

=IF(A1=0;"nula",(A1>0;"+",(A1<0;"-")))

U cemu je problem, u ovome zarezu izmedju dva IF?

b&s

unread,
Jan 5, 2011, 4:05:29 PM1/5/11
to
"Antonio Q" <tech...@gmail.com> wrote in message
news:iathzyryjvtv$.c94fz1k346v3$.d...@40tude.net

... problem je u tome da ti nedostaje jos koji IF i da si umjesto ;
(tocka-zarez) upisao , (zarez).
Evo ti 'korigirane' (tvoje) formule:
=IF(A1=0;"nula";IF(A1>0;"+";IF(A1<0;"-")))

--
pozdrav!
Berislav

Antonio Q

unread,
Jan 5, 2011, 4:28:36 PM1/5/11
to

Hvala puno (nisam to do sada nikad radio)

b&s

unread,
Jan 5, 2011, 4:35:11 PM1/5/11
to
"Antonio Q" <tech...@gmail.com> wrote in message
news:zj0sobfxfiem.1i...@40tude.net

> Hvala puno (nisam to do sada nikad radio)

... a evo i malo krace formule:
=IF(A1=0;"nula";IF(A1>0;"+";"-"))

--
pozdrav!
Berislav


Antonio Q

unread,
Jan 5, 2011, 5:04:49 PM1/5/11
to
On Wed, 5 Jan 2011 22:35:11 +0100, b&s wrote:

> "Antonio Q" <tech...@gmail.com> wrote in message
> news:zj0sobfxfiem.1i...@40tude.net
>> Hvala puno (nisam to do sada nikad radio)
>
> ... a evo i malo krace formule:
> =IF(A1=0;"nula";IF(A1>0;"+";"-"))

Da, istina, moze i tako ,
hvala jos jednom

b&s

unread,
Jan 6, 2011, 4:39:28 AM1/6/11
to
"Antonio Q" <ds...@deaw.ht> wrote in message
news:16zkv5t4njs8v$.tv21q90y...@40tude.net

>> ... a evo i malo krace formule:
>> =IF(A1=0;"nula";IF(A1>0;"+";"-"))
>
> Da, istina, moze i tako ,
> hvala jos jednom

... molim! I drugi put, ako zatreba ... ;-)

--
pozdrav!
Berislav


0 new messages