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 |
#2
|
|||
|
|||
How about:
in c12: =if( (A1*10)-100<1200, 1200, (A1*10)-100 ) "Tracey" wrote in message ... 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 |
#3
|
|||
|
|||
Perhaps in C12:
=MAX((A1*10)-100,1200) HTH. :) -- Dana DeLouis Win XP & Office 2003 "Tracey" wrote in message ... 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 |
#4
|
|||
|
|||
Thank-you very much Lewis and Dana for your help, much appreciated
|
Reply |
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 |