Demetriusthornton
New Member
- Joined
- Nov 1, 2005
- Messages
- 4
Can someone please help me with this formula.
=IF(G36>499999,G5*H5,200,else IF(G36>500000,G5*H5,"150.00",else IF(G36>1000000,G5*H5,"100",else IF(G36>5000000,G5*H5,"90.00","No Match"))))
What I am trying say is If G36 is less then 500.000, and G5*H5 is equal to or less then 200.00 then return a value of 200.00 if G5*H5 is greater then 200.00 then return the greater value. Please help me figure out where i went wrong with this one.
=IF(G36>499999,G5*H5,200,else IF(G36>500000,G5*H5,"150.00",else IF(G36>1000000,G5*H5,"100",else IF(G36>5000000,G5*H5,"90.00","No Match"))))
What I am trying say is If G36 is less then 500.000, and G5*H5 is equal to or less then 200.00 then return a value of 200.00 if G5*H5 is greater then 200.00 then return the greater value. Please help me figure out where i went wrong with this one.