| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then Statement
I want to do an If then statement in Excel like If I2 = mudstone and I3 =
Coal the value is 1. I have worked on this all afternoon and I am stumped! Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then Statement
Hi
IF(AND( I2 ="mudstone", I3 ="Coal"),1,"") - - Regards Roger Govier "Add to distribution list without opening" icrosoft.com wrote in message ... I want to do an If then statement in Excel like If I2 = mudstone and I3 = Coal the value is 1. I have worked on this all afternoon and I am stumped! Please help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then Statement
See if this will do what you want,
=IF(AND(I2="mudstone",I3="Coal"),1,"") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Add to distribution list without opening" icrosoft.com wrote in message ... I want to do an If then statement in Excel like If I2 = mudstone and I3 = Coal the value is 1. I have worked on this all afternoon and I am stumped! Please help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then Statement
Add to distribution list without opening wrote: I want to do an If then statement in Excel like If I2 = mudstone and I3 = Coal the value is 1. I have worked on this all afternoon and I am stumped! Please help! This works on my PC: =IF(AND(A1="mudstone",B1="coal"),1,0) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then Statement
=IF(AND(I2="mudstone",(I3="Coal")),1,"message when not")
Entered in I4 or wherever. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 16:03:01 -0700, Add to distribution list without opening icrosoft.com wrote: I want to do an If then statement in Excel like If I2 = mudstone and I3 = Coal the value is 1. I have worked on this all afternoon and I am stumped! Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
