Hi, i have a question which wants me to input a formula so that if the number is less than 2 in the cell "Day tripper" appears and if its more than 30 "too long" will appear.
This is the formula i have got so far.
=IF(I10="Less than 2","Day Tripper","Too Long")
Where have i gone wrong, as nothing seems to work.
Last edited by Haydn_17; 01-19-2010 at 07:34 AM.
You have typed in a string. You should use
< for less than
> forgreater than
=IF(I10<2,"Day Tripper","Too Long")
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Oh god yes! Thanks it's all coming back now thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks