Numbers 09 - Calculation of interest rate

Question

Level 1

0 points

Numbers 09 - Calculation of interest rate

With Numbers 08 I was easily able to add a simple formula into a self-made cashbook, which calculated interest. When the text "Interest" was added to one column another column calculated the interest and inserted it, using the following formula - IF (c4="Interest", f4*f$1).

Numbers 09 will not allow this formula and I cannot find a replacement. Can anyone help me with this.

Roy

MacPro, Mac OS X (10.5.6)

Posted on May 5, 2009 7:39 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

May 5, 2009 8:31 AM in response to RoyMcKee

Which is the exact behavior of the given formula.

Here it behaves flawlessly.

Of course, as you gave only two parameters in a formula supposed to embed three of them, if the condition C4="Interest" is not matched, you will get the result FALSE.

I would use

=IF (C4="Interest", F4*F$1,"")

This question was an opportunity to discover a change introduced by the late update (Numbers v2.0.1)

The program returns to its old bad habit.
Blank cells are again treated as zeroes when used with operators + or * 😟

Oops,
may you check which is the decimal separator used in your system?
If it is the comma, you must use the semi-colon as parameters separator.

=IF (C4="Interest"; F4*F$1;"")

Yvan KOENIG (from FRANCE mardi 5 mai 2009 17:29:11)

Reply

Answer 2

RoyMcKee Author

Level 1

0 points

May 5, 2009 9:13 AM in response to KOENIG Yvan

Thanks, that worked with the commas (but not with the semi colons).

Reply

Answer 3

KOENIG Yvan

Level 8

41,819 points

May 5, 2009 12:27 PM in response to RoyMcKee

I'm not in front of your machine so I can't guess which is your setting.

Yvan KOENIG (from FRANCE mardi 5 mai 2009 21:27:41)

Reply