TechSpot

No luck with an Excel formula

By johnd85
Mar 12, 2005
  1. I am green when it comes to Excel and I am trying to enter a formula in the Data Valdation box. I have no problem getting the desired result if I only need to use one argument but if I have to use two I get stumped. For instance, if cell b is less than 33 then use b+5. (that part works) but if b is greater than 33 then I want to use b*.15+h. I hope this makes sense and someone can help me out.
     
  2. RealBlackStuff

    RealBlackStuff TS Rookie Posts: 6,503

    In Help, type in the keyword IF_worksheet_function and select the IF text or the OR text.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...