Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell dependent on another
Need help with an If statement which refers to different sheets.
In Cell B2 is where I want the value returned If Sheet1 B4 not equal to "pens", put "Not applicable" in cell B2 Otherwise, put the value of Sheet3 C12 in cell B2 Can I get help with this formula? Thanks in advance |
#2
|
|||
|
|||
Try this: =IF(B4="pens",[contents of Sheet 3 C12],"Not applicable"). The
trick is that you can't use a "not equal to" value in an IF statement, so you have to turn it around so the first IF possibility is positive (E6 equals "pens"), the second negative. "jhicsupt" wrote in message ... Need help with an If statement which refers to different sheets. In Cell B2 is where I want the value returned If Sheet1 B4 not equal to "pens", put "Not applicable" in cell B2 Otherwise, put the value of Sheet3 C12 in cell B2 Can I get help with this formula? Thanks in advance |
#3
|
|||
|
|||
try in B2
=if(Sheet1!B4<"pens","Not applicable",Sheet3!C12) "jhicsupt" wrote: Need help with an If statement which refers to different sheets. In Cell B2 is where I want the value returned If Sheet1 B4 not equal to "pens", put "Not applicable" in cell B2 Otherwise, put the value of Sheet3 C12 in cell B2 Can I get help with this formula? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |