LinkBack URL
About LinkBacks
I have a situation where I want,
If C3 is Negative then D2 * 1.07 minus C3, otherwise (if C3 is positive)
Then C3 * 1.07 +D2
How do I enter That?
Thanks, Lamont
I have a situation where I want,
If C3 is Negative then D2 * 1.07 minus C3, otherwise (if C3 is positive)
Then C3 * 1.07 +D2
How do I enter That?
Thanks, Lamont
MaybeFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I tried that formula and get a 509 error, >>Operator is missing, for example, "=2(3+4) * ", where the operator between "2" and "(" is missing. <<Originally Posted by TMS
MaybeFormula:Please Login or Register to view this content.
I'm not seeing the error.
Ah, just found it, the commas need to be semicolons. =IF(C3<0; D2 * 1.07 - C3; C3 * 1.07 + D2) Thanks!
Now to verify the formula does what I want it to.
You're welcome. Thanks for the rep.
I guess your Regional Settings aren't what I would have expected
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks