IF argument and words

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I've set up a IF function that looks at one cell that
contains text, if the text is "A" then insert contents of
B2. Is it possible for Letters to be part of a Logical
statement?
If not, is there a different way to accomplish this?
Here is the basic string
=IF(Sheet1!I3="Bill",Sheet1!J3,"")
I'm taking time and marking it by words (Bill, Travel,
Warranty, ect.) and then depending on the word on one
sheet, putting the minutes into several different
categories...
 
Hi- I think you need to provide a clearer explanation of what you're trying
to do. Whatever it is, it sounds like it should be easy.

Maybe the INDIRECT function will work?
 
----- Peter wrote: -----

I've set up a IF function that looks at one cell that
contains text, if the text is "A" then insert contents of
B2. Is it possible for Letters to be part of a Logical
statement?
If not, is there a different way to accomplish this?
Here is the basic string
=IF(Sheet1!I3="Bill",Sheet1!J3,"")
I'm taking time and marking it by words (Bill, Travel,
Warranty, ect.) and then depending on the word on one
sheet, putting the minutes into several different
categories...

what are the contents of b2?
In your logical statement Sheet1!I3="Bill" then if that is true you can either put T(Cell) to return text if b2 is text or N(Cell) to return b2 if it is a value
 
I wish I knew what was wrong with it... It just returns a
blank even though it should be returning a whole number.
B2 contains the sum of Time Out minus Time In expressed in
minutes.
Simply put (as possible) I have a simple time sheet for
use with my PDA. It has a time in and a time out for each
job/task. I then calculate the minutes spent on each
job/task in another cell. In order to tell those minutes
which column they belong in (the columns are Billable,
$Billed, Warranty, Prefield, Travel, Productive Office,
Non Productive Office, Other, Callback... You see why I
don't want to have to remember which number refers to
which category. I have shortened the input to Bill, Warr,
ect.) I have another sheet which is the printable version.
The formula in each column is referring to sheet1, the
cell that I have input text - Bill, ect. and if True then
returning to that cell in the Printable Sheet the total
minutes for that job/task.
Again the formula I'm using is
=IF(Sheet1!I3="Bill",Sheet1!J3,"")
This formula is on Sheet2 - labeled Redding timesheet.
I tried the Indirect function but don't understand how it
works...
I can email it to anyone who wants a better
understanding...
drz400thumper - at - sbcglobal.net
 
Back
Top