| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
F Function help! I have two cells!!
I have two variables, i.e. two cells determine what is displayed... does
anyone know the formula to this... Would be like "if A2 is = B2 AND if cell C2 = D2 then diplay E2" =IF(A2=B2&,if(C2=D2,E2)) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
F Function help! I have two cells!!
rose;453434 Wrote: I have two variables, i.e. two cells determine what is displayed... does anyone know the formula to this... Would be like "if A2 is = B2 AND if cell C2 = D2 then diplay E2" =IF(A2=B2&,if(C2=D2,E2)) =IF(And(A2=B2,C2=D2),E2,"") -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125521 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tab function within cells | Excel Worksheet Functions | |||
| Using IF function for many many cells, and using more than one IF function | Excel Worksheet Functions | |||
| How to add two cells when one uses IF function? | Excel Discussion (Misc queries) | |||
| Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
| If function with blank cells | Excel Worksheet Functions | |||
Linear Mode
