| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help to write a formula using a letter value and a number value
Where are you putting this formula? You're looking for 5 results from 5 cells Q4:U4, do you want results in 5 different cells? This should work for one cell =IF(ISNUMBER(Q4),IF(OR(Q4=0,Q459),"Z",A4),A4) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=506058 |
Threaded Mode
