Re: Using Formulae in If statements

Thanks for the prompt reply on this one. I don't think I was clear enough for
what I wanted.

I am looking for a specific formula to be entered in cell F3, i.e.

=IF(D3+D3<E3,"URGENT","").

No other formula would be acceptable.

So in G3 I'm trying to enter an IF statement of my own that would comment
Correct or Try Again depending on the formula entered by the student. Does
that make sense? A number of students will have this exercise to work through
and I'm trying to make it a bit more interactive so that they can see if they
are correct. (Also helps to reduce my marking time :-) ).

Tazzy

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200803/1

.

Relevant Pages

  • Re: No clue whatsoever, so thought Id ask the experts
    ... On Jan 27, 10:15 am, Gary''s Student ... > Sub AskMeNoQuestions() ... >> thing) to prompt a window to pop up with a Label ...
    (microsoft.public.excel.programming)
  • RE: No clue whatsoever, so thought Id ask the experts
    ... Gary''s Student - gsnu2007L ... "Paul" wrote: ... to which I woudl type the data/answer. ... thing) to prompt a window to pop up with a Label "What is ...
    (microsoft.public.excel.programming)
  • Re: No clue whatsoever, so thought Id ask the experts
    ... Sub AskMeNoQuestions() ... Gary''s Student - gsnu200829 ... to which I woudl type the data/answer. ... thing) to prompt a window to pop up with a Label "What is ...
    (microsoft.public.excel.programming)
  • Re: lost
    ... write a class Student to solve the parallel array problem. ... > private int score; ... > public String getName() // Gets the name of the Student ... possible that you are supposed to prompt at the command line. ...
    (comp.lang.java.help)
  • Re: No clue whatsoever, so thought Id ask the experts
    ... If I created my own UserForm to make it look like I wanted, ... Gary''s Student - gsnu200829 ... to which I woudl type the data/answer. ... thing) to prompt a window to pop up with a Label "What is ...
    (microsoft.public.excel.programming)