If Statement in need of HELP

[MicheleY]

I am trying to write a formula for this: If cell b1 can be any $ amount and
cell c1 can be "quarterly", "monthly", semi-annual, yearly, or bi-monthly. I
want my result to be if b1 is =<100 and c1="quarterly", b1 otherwise b1/4, or
if b1=<100 and c1="monthly", b1 otherwise b1/12 and so on.

 

[Bob Greenblatt]

I am trying to write a formula for this: If cell b1 can be any $ amount and
cell c1 can be "quarterly", "monthly", semi-annual, yearly, or bi-monthly. I
want my result to be if b1 is =<100 and c1="quarterly", b1 otherwise b1/4, or
if b1=<100 and c1="monthly", b1 otherwise b1/12 and so on.

=if(b1<=100,if(c1="quarterly",b1/4,if(c1="monthly",b1/12,if(c1="bi-monthly",
b1/2,if(c1=semi-annual",b1/6,b1)))))

 

[MicheleY]

thanks bob

 

[JE McGimpsey]

I am trying to write a formula for this: If cell b1 can be any $ amount and
cell c1 can be "quarterly", "monthly", semi-annual, yearly, or bi-monthly. I
want my result to be if b1 is =<100 and c1="quarterly", b1 otherwise b1/4, or
if b1=<100 and c1="monthly", b1 otherwise b1/12 and so on.

One way:

=B1/IF(B1<=100, 1, LOOKUP(C1,
{"bi-monthly","monthly","quarterly","yearly"}, {6,12,4,1}))