| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula
Cell M2 has YES. I want to display the content of L2 (35) in N2, if m2 is yes.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
=IF(M2="yes",N2,"")
Vaya con Dios, Chuck, CABGx3 "debbie" wrote: Cell M2 has YES. I want to display the content of L2 (35) in N2, if m2 is yes. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
In N2 put this formula in, =IF(M2="yes", L2, "") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556543 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
Sorry, mis-read........should have been like what Bearacade said....
=IF(M2="yes",L2,"") Vaya con Dios, Chuck, CABGx3 "CLR" wrote: =IF(M2="yes",N2,"") Vaya con Dios, Chuck, CABGx3 "debbie" wrote: Cell M2 has YES. I want to display the content of L2 (35) in N2, if m2 is yes. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formula
Nel post
*debbie* ha scritto: Cell M2 has YES. I want to display the content of L2 (35) in N2, if m2 is yes. in N2 type: =IF(M2="YES",L2,"") -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
