| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 115843 | 2011-02-06 07:16:00 | OOO Calc Formula | Phil B (648) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1175574 | 2011-02-06 07:16:00 | I'm trying to do a simple formula, I've no idea what I'm doing, but I know what I want it to do. If the value in cell C3 is less than B3 & the value of B3 is less than A3, I want it to print a "1" in D3. If the values are opposite (greater), to print a "2" in E3. I want the calculations done automatically as I enter for all the columns. If the values are anything other than less or greater, leave the cells blank. I don't need the columns totalled. When I've got that figured out & some data entered, I'll move on to the next formula Any ideas?? |
Phil B (648) | ||
| 1175575 | 2011-02-06 08:44:00 | =IF(C3<B3;IF(B3<A3;1;"");"") =IF(C3>B3;IF(B3>A3;2;"");"") |
Steven (7085) | ||
| 1175576 | 2011-02-06 09:05:00 | Hi Steven, thanks for the reply. It comes up with error 508 If I enter =IF(C3<b3andb3<A3; "1") it reports #NAME?. Ideally I want the #NAME? to be 1 |
Phil B (648) | ||
| 1175577 | 2011-02-06 09:17:00 | Use the formula that I posted. | Steven (7085) | ||
| 1175578 | 2011-02-06 09:17:00 | If I have understood correctly what you want is: =IF(AND(C3<B3,B3<A3),1,IF(AND(C3>B3,B3>A3),2," ")) |
johnd (85) | ||
| 1175579 | 2011-02-06 09:19:00 | Just noticed you want to 1 and 2 in different cells - sorry | johnd (85) | ||
| 1175580 | 2011-02-06 09:23:00 | Steven.. I copied & pasted your formula & it reported error 508 Johnd.. I did the same with yours & it reported error 508 also. You did understand what I'm after. I can see what you're trying to do. Error 508 apparantly means brackets missing |
Phil B (648) | ||
| 1175581 | 2011-02-06 09:28:00 | Strange - mine was a copy and paste from the SS to the forum - was working! One thing I have not worked out though - why does Calc sometimes want a "," and sometimes a ";"?? |
johnd (85) | ||
| 1175582 | 2011-02-06 09:30:00 | Open office calc file doing what you asked for. www.sendspace.com |
Steven (7085) | ||
| 1175583 | 2011-02-06 09:33:00 | johnd it looks like you have posted an excel formula not open office. | Steven (7085) | ||
| 1 2 | |||||