Prev Previous Post   Next Post Next
  #1   Report Post  
HRMSN
 
Posts: n/a
Default IF Function

I am trying to use the IF function to assess the following:

If any of five or so cells has a number in it (any number) then place in
this cell where the formula is, a label corresponding to the source cell that
has a number in it.

For instance, if my staff person indicated they used 5 hours of vacation
time because they placed the number 5 in a specific cell, then I want the
letter V to be placed here.

I believe I know what to do, but what might be the simplest way to help me
is answering this. Is there a symbor or something that will indicate that
any number will do, or is there a symbor that is opposite of "="?

Hope this makes sense...

HR Specialist
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 07:07 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"