| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks very much.
"bj" wrote: try =if(verified="V","V",if(moderated="M","M",if(compe tent="C","C",if(received="R","R","")))) where verified is the appropriate cell in the "Verified"column, etc. "Gailwdz" wrote: Thank you. It did help, but I think I need a nested formula. My data looks a little like this: US Received Competent Moderated Verified 114943 R C M V R C M What I'm trying to do is determine at which stage the US is at. Example - the unit standard has been received and marked competent, but has not been verified yet - then the formula must determine that the cell marked V is empty, and then determine whether the cell marked M is empty or not, and so on. The formula should also check the columns from right to left, to see at what stage the unit standard is at, at present. I hope that's not as confusing to you as it sounds to me! "Bob Phillips" wrote: Sounds like IF =IF(Sheet1!A1="A", A1,B1) -- HTH Bob Phillips "Gailwdz" wrote in message ... I'm trying to create a link between worksheets that chooses between two values in two different cells, and chooses one of them. What function, if any, could I use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clock | Excel Worksheet Functions | |||
| insert row within function | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Insert Function "FX" on Toolbar in Excel | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Threaded Mode
