I have data that contains 2 columns: "terms" and "rate". Terms is either

"monthly" or "weekly". I want to create a formula for a pivot table that

computes the Annual amount.

My formula is as follows:

=IF(terms="monthly",12*Rate,IF(terms="weekly",52*Rate,0))

The result is always 0. I have trimmed my terms column but to no

vail..

If I create a formula:

=IF(terms="monthly",12*Rate,52*Rate)

This works. It s not what I want since eventually the terms column will

inlcude quarterly and bi-monthly options which will require a nested IF

If I use the IIF function, I get an error and it wont let me enter that

function.

I am not sure what I am doing wrong.

Jack

## Bookmarks