Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a Formula
I need to create a formula that basically says: If A2 is less than 200,000.00
then multiply A2 by rate. Can anyone help the only thing I can find tells me that it is true of false and I need the value to calculate. |
#2
|
|||
|
|||
Creating a Formula
What if it is not less than 200,000?
If you require it to remain the same: (if the rate is in A3) =IF(A2<200000,A2*A3,A2) -- Kind regards, Niek Otten "Cin" wrote in message ... I need to create a formula that basically says: If A2 is less than 200,000.00 then multiply A2 by rate. Can anyone help the only thing I can find tells me that it is true of false and I need the value to calculate. |
#3
|
|||
|
|||
Creating a Formula
ONe way:
=IF(A2<200000, A2*rate, "A2 not less than 200,000") In article , Cin wrote: I need to create a formula that basically says: If A2 is less than 200,000.00 then multiply A2 by rate. Can anyone help the only thing I can find tells me that it is true of false and I need the value to calculate. |
#4
|
|||
|
|||
Creating a Formula
=IF(A2<200000,A2*rate,"")
-- HTH RP (remove nothere from the email address if mailing direct) "Cin" wrote in message ... I need to create a formula that basically says: If A2 is less than 200,000.00 then multiply A2 by rate. Can anyone help the only thing I can find tells me that it is true of false and I need the value to calculate. |
#5
|
|||
|
|||
Creating a Formula
"Cin" wrote:
I need to create a formula that basically says: If A2 is less than 200,000.00 then multiply A2 by rate. .... Else what? Try: =IF(A2 < 200000, 200000*rate, 200000) That assumes if the A2 is not less than 200,000, you simply want 200,000. By the way, that also assumes that "rate" is the exact multiple you are interested in. If instead you intended to say "increases 200,000 by a rate", replace "rate" by "(1+rate)" above. Finally, some might suggest the following alternative: =IF(A2 < 200000, 200000*rate) IMHO, that is very poor form because it will return the value FALSE, not a value of the same units as 200000. Normally that creates problems later. If you want the cell to appear blank in the false condition, write: =IF(A2 < 200000, 200000*rate, "") Caveat: Although the resulting cell might appear to be empty in the false condition, it does not behave exactly the same as a truly empty cell in all cases for other formulas that depend on that cell. |
#6
|
|||
|
|||
Creating a Formula
Hi!
What do you want to do if A2 = 200,000 ? =IF(AND(A2<"",A2<200000),A2*Rate,"") If A2 = 200,000 the formula leaves the cell blank. (not to be confused with EMPTY) Biff "Cin" wrote in message ... I need to create a formula that basically says: If A2 is less than 200,000.00 then multiply A2 by rate. Can anyone help the only thing I can find tells me that it is true of false and I need the value to calculate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating charts from formula results | Excel Discussion (Misc queries) | |||
Creating a specific formula | New Users to Excel | |||
Help with creating Formula again | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |