I need to run a formula that will look and see if data is greater then, equal to or lesser then a condition and if it is then multiply a cell by another cell but I'm having problems with it.
Here is the forumla that I've written, can anyone please assist.
=IF(H27<=4,D27*0%,IF(H27>=5<=9,D27*3%,IF(H27>=10<=14,D27*4%,IF(H27>=15<=19,D27*6%,IF(H27>=20<=24,D27*7%,IF(H27>=25,D27*8%))))))
This forumla is returning FALSE into the cell.
Info for the cells
H27=15, D27=$28,912.00 - so the calculation should be calculating that H27 being 15, should take the $28,912.00 and multiply that figure by 6%.
I hope I've been clear enough on my example.
Thanks in advance for any help.
Tami
Here is the forumla that I've written, can anyone please assist.
=IF(H27<=4,D27*0%,IF(H27>=5<=9,D27*3%,IF(H27>=10<=14,D27*4%,IF(H27>=15<=19,D27*6%,IF(H27>=20<=24,D27*7%,IF(H27>=25,D27*8%))))))
This forumla is returning FALSE into the cell.
Info for the cells
H27=15, D27=$28,912.00 - so the calculation should be calculating that H27 being 15, should take the $28,912.00 and multiply that figure by 6%.
I hope I've been clear enough on my example.
Thanks in advance for any help.
Tami