[demirkol]

I dont get the "IF" formula it confuses me. I need it for my IT work because i am going to need to learn how to use that formula because i need it for the whole year.

[Advertisements]

The IF statement is broken into 3 parts

1. A Test
2. A result to display if the Test is True
3. A result to display if the Test is False

all 3 parts can include text, numbers or cell references

example Tests
3>0
3=0
3<0
A5="Bob"

example syntax
=IF(3>0,"my test passed", "my test failed")
=IF(A5>B5, A5, "zzz")


Best way to learn is try it out
HTH

[dsm]

The IF statement is broken into 3 parts

1. A Test
2. A result to display if the Test is True
3. A result to display if the Test is False

all 3 parts can include text, numbers or cell references

example Tests
3>0
3=0
3<0
A5="Bob"

example syntax
=IF(3>0,"my test passed", "my test failed")
=IF(A5>B5, A5, "zzz")


Best way to learn is try it out
HTH

[demirkol]

what is HTH?

[dsm]

Hope This Helps.

PS. Did my explanation help ?

[demirkol]

i can do the things you told me but when i have to answer questions i cant do it