if the excel statements

[cknipe]

Lets say I have numbers in Column. C2 is how many units I billed last month, C4 is how many units I counted this month. I would like for C3 to copy the value of C2 if C5 is less than 0. However if C5 is greater than 0 I would like for c3 to equal the value of C4 . Is this function possible in excel?

C2 - 5000
C3 - <formula result>
C4 - 4999
C5 - -1

 

[mintjulep]

Yes.

 

[SkipVought]

I agree!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cmeagan656]

Only ask questions with yes/no answers if you want "yes" or "no"

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.
Canadian members check out Tek-Tips in Canada for socializing, networking, and anything non-technical.

 

[combo]

If C5 is calculated as a difference (C4-C2), use MAX(C2, C4).

combo

 

[lionelhill]

Okay, okay, everyone here is pedantic.
=if(C5<0, C4, C2)
(function "if" has three parameters, condition-to-test, value-if-true, value-if-false)

 

[lionelhill]

oh, and I'm pedantic too: You didn't specify what to do if C5=0.