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
|
|||
|
|||
If functions
I want to set up a formual so that if H12 is yes, I
want G12 equal to B11, If it is No i want it left blank, is that possible to do? |
#2
|
|||
|
|||
If functions
Entered in G12:
=IF(H12="yes",B11,"") -- Biff Microsoft Excel MVP "Muskrat24" wrote in message ... I want to set up a formual so that if H12 is yes, I want G12 equal to B11, If it is No i want it left blank, is that possible to do? |
#3
|
|||
|
|||
If functions
You should really stay in the original thread. If you had done that, you
would see that I had already posted the formula Biff posted some 10 minutes earlier. -- Rick (MVP - Excel) "Muskrat24" wrote in message ... I want to set up a formual so that if H12 is yes, I want G12 equal to B11, If it is No i want it left blank, is that possible to do? |
Thread Tools | |
Display Modes | |
|
|