| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
2 formulae to go in one cell
Hello,
I have this simple formula which populates cell C12 with a value =(A1*10)-100 I then want to check the resulting value and if it is less then 1200, set the value of C12 to 1200 anyway. If the result is over 1200 then I want it to show the result of the formula. Is this possible? I was hoping just to join the first formula with this one: =IF(C12<1200,1200,IF(C121200,C12)) but it doesn't work! Thanks again for any help Tracey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| how can i test whether cell contains keyed constant or a formulae | Excel Worksheet Functions | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
