Home > IT Answers > AS/400 > If Function
Newinfrance
15 pts.
 If Function
function, IF, OR
is there ONE multiple IF function formula to inclue all of the below if INS = nd and order is less than 5000 then 0% - - if INS = nd and order is 5000 to 11999 then 70% - if INS = nd and order is 12000+ then 8400/order if INS has a value then INS/order

Software/Hardware used:
ASKED: May 7, 2009  6:48 PM
UPDATED: December 15, 2009  1:41 AM
RELATED QUESTIONS
Answer Wiki:
Try using the select case statement. See the link below for more information. http://www.ozgrid.com/VBA/select-case.htm
Last Wiki Answer Submitted:  December 15, 2009  1:41 am  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What software do you want to do this on ?

carlosdl
 63,535 pts.
 

Hi there,

Yes, can you please provide more information? We need to know what software you are using in order to help answer your question.

Thank you,
Jenny
Community Manager

JennyMack
 4,265 pts.
 

Hiya…

Excel 2003. Thanks!!

Newinfrance
 15 pts.