| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 if statements
I have a cell (cell C) that has an if statement in it. The statement is, if
cell A is greater than or equal to 15000 than this cell equals cell B. I also want to put another if statement in that reads if cell B is greater than 15000 then this cell equals 15000. =if(a1=15000,b1,0) =if(b1=15000,15000,b1) how can I put these 2 statements into 1 cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 if statements
nevermind, I solved
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 if statements
Depents on priorities of the decisions which is better for you:
=IF(A1=15000;B1;IF(B115000;15000)) or =IF(B115000;15000;IF(A1=15000;B1)) You did not specify what if both A and B are less than 15000. Put that after last argument. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
2 if statements
Matthew,
Try this.... =IF(A3=15000,IF(B3=15000,15000,B3),0) Is that what you are after ? Donna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| If Statements: | Excel Discussion (Misc queries) | |||
| If Statements | Excel Discussion (Misc queries) | |||
| If... Then statements | Excel Discussion (Misc queries) | |||
| using if statements | Excel Worksheet Functions | |||
Hybrid Mode
