On Mar 1, 11:53*am, "Tazzy via OfficeKB.com" <u26845@uwe wrote:
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.

Why not any of the following:

=if(E3D3+D3,"URGENT","")

=if(D3+D3=E3,"","URGENT")

=if(E3-D3D3,"URGENT","")

...etc etc etc...

Not to mention that "D3+D3" can be written "2*D3"; and if you meant
"D2+D3", it can be written "D3+D2". And not to mention adding
whitespace at their discretion.

If you want your students to simply parrot what you think
(incorrectly) is the only or best answer, you should give them a
multiple choice, rather than ask them to be creative. Perish the
thought!