A simple "if" function

[gthorley]

I used to be able to set these up in 123 but I guess I am getting old.

Can someone give me the correct if function to get the following result

If the balance cell is greater than 0 then the amount under monthly is (1000*.03)/12 and if negative then -(1000*.06)/12

-------------------monthly-------balance
Cash(Margin)--------- 0--------- 1000

This is what I entered in the monthly cell with the balance being cell H3 and it doesn't work

=IF(H3<0,(0.0675*H3)/12),(0.0312*H3)/12

 

[Smitty]

You just had a paren in the wrong place:

=IF(H3<0,(0.0675*H3)/12,(0.0312*H3)/12)

HTH,

 

[Yogi Anand]

Hi gthorley:

Please note that in your formula ...

=IF(H3<0,(0.0675*H3)/12,(0.0312*H3)/12) (as re-presented by smitty)

the second argument will apply if Cell H3 is not less than 0 ... that means it will apply when H3 is =0 as well as when H3 is >0.

 

[gthorley]

Thanks for the correction. Yogi I did realize that and it will not effect the use I need.

I found that the following formula worked as well

=IF(H23<0,((0.0675*H23)/12),((0.0312*H23)/12))

and it has what seems to be uneeded parenthesis

=IF(H3<0,(0.0675*H3)/12,(0.0312*H3)/12)

 

[Smitty]

I used to be able to set these up in 123...

From what I recall it's really very similar, but I haven't used 123 since '94 or so...

I found that the following formula worked as well

=IF(H23<0,((0.0675*H23)/12),((0.0312*H23)/12))

and it has what seems to be uneeded parenthesis

Yup, but if you look in edit mode, Excel will actually color each successive open paren with its mate on the other end. I've found that really handy on some of my monstrous formulas (I don't remember if 123 did/does that or not).

it will apply when H3 is =0 as well as when H3 is >0.

Thanks for pointing that out Yogi, as I didn't. (And good to see you around! )