IF statement that yields a value based on a formula
in [Functions]
|
From: barbara h on 11 Feb 2010 11:59 Help! If cell B12 >= 0, then I need the answer to be calculated based on the formual "B12 * .40". If cell B12 < 0, then the answer is zero. How do I do this? -- barbara h
From: Eva on 11 Feb 2010 12:14 IF(B12>=0,B12*0.4,IF(B12,0,0)) Click yes if helped -- Greatly appreciated Eva "barbara h" wrote: > Help! If cell B12 >= 0, then I need the answer to be calculated based on the > formual "B12 * .40". If cell B12 < 0, then the answer is zero. > > How do I do this? > -- > barbara h
From: Mike H on 11 Feb 2010 12:15 Hi, Try this =MAX(0,B12*0.4) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "barbara h" wrote: > Help! If cell B12 >= 0, then I need the answer to be calculated based on the > formual "B12 * .40". If cell B12 < 0, then the answer is zero. > > How do I do this? > -- > barbara h
From: T. Valko on 11 Feb 2010 12:19 One way... =(B12>=0)*0.4 -- Biff Microsoft Excel MVP "barbara h" <barbarah(a)discussions.microsoft.com> wrote in message news:CEA214BD-9E90-4D3A-A92B-FDB2C3FEC8C7(a)microsoft.com... > Help! If cell B12 >= 0, then I need the answer to be calculated based on > the > formual "B12 * .40". If cell B12 < 0, then the answer is zero. > > How do I do this? > -- > barbara h
From: T. Valko on 11 Feb 2010 12:42 >>based on the formual "B12 * .40". >=(B12>=0)*0.4 Ooops! Disregard that formula. Here's a corrected version: =(B12>0)*(B12*0.4) -- Biff Microsoft Excel MVP "T. Valko" <biffinpitt(a)comcast.net> wrote in message news:ePHMs5zqKHA.3464(a)TK2MSFTNGP06.phx.gbl... > One way... > > =(B12>=0)*0.4 > > -- > Biff > Microsoft Excel MVP > > > "barbara h" <barbarah(a)discussions.microsoft.com> wrote in message > news:CEA214BD-9E90-4D3A-A92B-FDB2C3FEC8C7(a)microsoft.com... >> Help! If cell B12 >= 0, then I need the answer to be calculated based on >> the >> formual "B12 * .40". If cell B12 < 0, then the answer is zero. >> >> How do I do this? >> -- >> barbara h > >
|
Next
|
Last
Pages: 1 2 Prev: IF THEN Statement Next: finding duplicate addresses across 2 worksheets in the same workbo |