Replace formula

[Tom Jones]

Hello,

How can I replace this formula?
=IF(B14<5,0,IF(B14<10,5%,IF(B14<12,6%,IF(B14<15,7%,IF(B14>=15,10%)))))

[SamT]

Select the cell the formula is in and type something else.

That's a true and complete answer to your exact question.











IOW, We need more information.

[abraxus]

iterate thru the rows looking for that formula using VBA....

if sheets(0).Cells(0,0).Formula = "=IF(B14<5,0,IF(B14<10,5%,IF(B14<12,6%,IF(B14<15,7%,IF(B14>=15,10%))))) " then
sheets(0).Cells(0,0).Formula = "new formula goes here"
end if

[AMontes]

Try:
=LOOKUP(B14,{4,9,11,14,15;0,5,6,7,10})

[abraxus]

it really depends on what you are trying to lookup -and how - and how large your dataset is

[Tom Jones]

Select the cell the formula is in and type something else.

That's a true and complete answer to your exact question.

Very clever. I was interested in a formula equivalent to the one I wrote.

Thanks to all.

[mancubus]

you may adopt the formula posted by amontes;

=LOOKUP(B14,{0,5,10,12,15;0,0.05,0.06,0.07,0.1})

[SamT]

Glad you liked it. I wasn't sure you would see the humor.

I was interested in a formula equivalent to the one I wrote.

Thank you, that's what we need

[Tom Jones]

Thank mancubus and amontes.