IF function

[Ninja]

I am stuck with he IF function.
If a person is longer than one year at the firm he get 401k,3%,
Since there are many people in the firm and I have their time being a
the firm in C13, I need to calculate If ...
Anyone? thanks for your help in advance

 

[Norman Harker]

Hi Ninja!

How are you showing how long someone is at the firm?

If shown as days it will be different from if shown as months or years.

Now what do you want the IF function to do?

If longer than a year: 401000 + 3% of 401000, otherwise 401000.


eg

=IF(C13>=1,401000*1.03,401000)

But your argument separator might be ; and not ,
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ninja]

thank you for replying and hel