Microsoft Office Forums - View Single Post - I Need Help

Thread: I Need Help

View Single Post

Old

08-03-2011, 04:56 AM

robbiemer

robbiemer is offline

robbiemer uses Windows XP

Windows XP robbiemer uses Office 2007

robbiemer uses Office 2007

Office 2007

Novice

The original poster

Join Date: Aug 2011

Posts: 2

robbiemer is on a distinguished road

Default

thank you

with a little 'tweeking' i managed to get it working this is the final formula =IF(A2<9.99,A2*F2,IF(A2<99.99,A2*F3,IF(A2>100.01, A2*F4)))

Reply With Quote