Slight addition to a long if statement

**alias09** · 11-23-2009, 10:36 AM

Daddylonglegs solved me this if statement....

=IF(I24="Flat Rate Plan",B11+(D11*K24)+(E11*L24)+(F11*M24),IF(I24="1200 Minute Plan",IF(K24<H16,B12+(E12*L24)+(F12*M24),B12+D12*(K24-C12)+(E12*L24)+(F12*M24)),IF(I24="Imove 1800",IF(K24<H17,B13+F13*M24,B13+D13*(K24-C13)+(F13*M24)),IF(I24="Imove 3400",IF(K24<H18,B14+F14*M24,B14+D14*(K24-C14)+(F14*M24)),""))))

However, I forgot to put in this formula the tax rate of (.13)

That is in cell B8 on my spreadsheet.. I tried to fix it but it said I entered to many arguments.

I want each formula in the statement to be times by .13 after is is calculated.
How do I do this?

Thanks

**davesexcel** · 11-23-2009, 10:44 AM

You may have to put *.13 inside the nested ifs
=IF(I24="Flat Rate Plan",.13*(B11+(D11*K24)+(E11*L24)+(F11*M24)),IF
Be sure to add a bracket to each end.