IF Statements
in [General]
|
Prev: vlookup for max value or any value>0
Next: copy rows from one Data sheet to another sheet based on cell conte
From: Jillian on 13 May 2010 16:13 Hi, I was hoping someone would be able to assist me. I am looking for a formula where if I6<G6 then 0 BUT if I6>G6 then I6-G6. Basically if I6 is greater than G6 the cell needs to populate the difference. I have tried everything and I get is #NAME? or #VALUE errors. Thanks!
From: Mike H on 13 May 2010 16:39
Hi, This should do it =MAX(0,I6-G6) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jillian" wrote: > Hi, I was hoping someone would be able to assist me. I am looking for a > formula where if I6<G6 then 0 BUT if I6>G6 then I6-G6. Basically if I6 is > greater than G6 the cell needs to populate the difference. I have tried > everything and I get is #NAME? or #VALUE errors. > Thanks! > |