| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Functions
I am trying to make a function so that if the cell is "yes" that it will be
equal to another cell and if it is "no" than it is left blank. How do I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Functions
=IF(A1="Yes",B1,"")
That is a pair of double quotes with nothing between them The formula looks at A1 and if it has value Yes than the cell with the formula gets B1's value, otherwise it displays nothing. Of course, this formula can go in any cell other than A1 or B1 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Muskrat24" wrote in message ... I am trying to make a function so that if the cell is "yes" that it will be equal to another cell and if it is "no" than it is left blank. How do I do this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Functions
Try:
=IF(A1="Yes",B1,"") "Muskrat24" wrote: I am trying to make a function so that if the cell is "yes" that it will be equal to another cell and if it is "no" than it is left blank. How do I do this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Functions
I tried it and it wouldnt work. the way I want it set up is if H12 is yes, I
want G12 equal to B11, is that possible to do? "MurrayBarn" wrote: Try: =IF(A1="Yes",B1,"") "Muskrat24" wrote: I am trying to make a function so that if the cell is "yes" that it will be equal to another cell and if it is "no" than it is left blank. How do I do this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Functions
Try putting this formula in G12...
=IF(H12="Yes",B11,"") -- Rick (MVP - Excel) "Muskrat24" wrote in message ... I tried it and it wouldnt work. the way I want it set up is if H12 is yes, I want G12 equal to B11, is that possible to do? "MurrayBarn" wrote: Try: =IF(A1="Yes",B1,"") "Muskrat24" wrote: I am trying to make a function so that if the cell is "yes" that it will be equal to another cell and if it is "no" than it is left blank. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Hybrid Mode
