| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula: if A1 is greater than B1 and A1 is greater than zero..
Hello everyone,
this is what I came up with so far: =IF(G2=F2, "YES", "NO") now I have to add F2 must also be greater than zero before putting a "YES" how do i do that? thank you :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula: if A1 is greater than B1 and A1 is greater than zero..
Jason
I would add a second IF statement in the =IF(F20, (IF(G2=F2,"YES","NO"), "NO") ) I think the format is correct, but did not test it..... "Jason" wrote: Hello everyone, this is what I came up with so far: =IF(G2=F2, "YES", "NO") now I have to add F2 must also be greater than zero before putting a "YES" how do i do that? thank you :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula: if A1 is greater than B1 and A1 is greater than zero..
Hi,
Use AND =IF(AND(F20,G2=F2), "YES", "NO") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jason" wrote: Hello everyone, this is what I came up with so far: =IF(G2=F2, "YES", "NO") now I have to add F2 must also be greater than zero before putting a "YES" how do i do that? thank you :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula is greater than X use it, if not use X | Excel Worksheet Functions | |||
| If Formula using Greater than / Less than | Excel Discussion (Misc queries) | |||
| Formula greater than | Excel Worksheet Functions | |||
| Formula Greater than Less Than | Excel Discussion (Misc queries) | |||
| Greater Than formula | Excel Worksheet Functions | |||
Linear Mode
