#1
|
|||
|
|||
Return the value of a cell
HI!
Is it possible to have a formula in excel that checks if E5, F5,G5,H5,I5 are empty and if it is not then return a value for the cell that is not empty? I have a worksheet where the person needs to mark one of those cells and I need a formula that if the marked one is E5 then return the letters EE if the marked one is F5 return LL, if the marked one is G5 return BP, if the marked one is H5 return 504 or if the marked one is I5 return D. Can this be possible? if so how? I HAVE TRIED THIS: =IF(AND(SUBGRUPOS!E5="EE","EE","",SUBGRUPOS!F5="LL ","LL","",SUBGRUPOS!G5="BP","BP","",SUBGRUPOS!H5=" 504","504","",SUBGRUPOS!I5="D","D",),"") BUT IT RETURNS A #VALUE ERROR Last edited by piper7971; 06-09-2015 at 06:22 AM. Reason: SOLVED |
#2
|
||||
|
||||
Try:
=IF(E5<>"","EE",IF(F5<>"","LL",IF(G5<>"","BP",IF(H 5<>"",504,IF(I5<>"","D","")))))
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Yes!!!! Thanks a lot!
|
#4
|
|||
|
|||
Hoe do i post it as solved?
|
#5
|
||||
|
||||
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find text within cell and return column and row title next to the name on a new sheet. | tanyabowring@live.co.uk | Excel Programming | 2 | 03-26-2015 01:48 AM |
How to return the first cell in a row? | dapeamel | Excel | 0 | 02-26-2015 12:56 AM |
Search for multiple texts in cell, return specific text | mariur89 | Excel | 4 | 12-14-2014 01:33 AM |
Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
Return cuurent time when another cell is updated | zks | Excel | 6 | 01-22-2012 10:24 PM |