| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statements Help!
In Excel, can you write IF Then statements in a formula. for example if
V2=0 then "MEET" Now I already have a formula in V2, I am looking to add the conditional statement to that formula, and if the answer is true then I need V2 to read "OK" if if V2 is false then I need V2 to read "Not OK" Thank Brain |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Statements Help!
Try the following:
=IF(V2=0,"OK","Not OK") -- Kevin Backmann "Brian" wrote: In Excel, can you write IF Then statements in a formula. for example if V2=0 then "MEET" Now I already have a formula in V2, I am looking to add the conditional statement to that formula, and if the answer is true then I need V2 to read "OK" if if V2 is false then I need V2 to read "Not OK" Thank Brain |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional statements | Excel Worksheet Functions | |||
| Conditional Format - MIN, IF statements | Excel Worksheet Functions | |||
| More than 3 conditional statements or macro or ?? | Excel Discussion (Misc queries) | |||
| Conditional IF statements | Excel Worksheet Functions | |||
| Conditional Statements | Excel Discussion (Misc queries) | |||
Hybrid Mode
