|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2009, 07:14 PM
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
June 15th, 2009, 07:19 PM
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
June 15th, 2009, 07:24 PM
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
June 15th, 2009, 07:41 PM
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
June 15th, 2009, 07:53 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
