 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008help with formula
G12 has a dropdown menu in it, Y for YES, N for NO. I12 is where the answers will go. So if I pick N from the dropdown box in G12 , I need it to show a answer of 0 in I12. If I choose Y in cell G12 , I need it to use this formula =Roundup(E12/300,0) so that it will give me a answer in cell I12. How to I write this and get it to work? Place in I12: =IF(G12="Y",ROUNDUP(E12/300,0),0)  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > G12 has a dropdown menu in it, Y for YES, N for NO. > I12 is where the answers will go. > So if I pick N from the dropdown box in G12 , I need it to show a answer of 0 > in I12. If I choose Y in cell G12 , I need it to use this formula > =Roundup(E12/300,0) so that it will give me a answer in cell I12. How to I > write this and get it to work?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.