LinkBack URL
About LinkBacks
Hello! I am finishing up my incentive formula and stuck on issue. See attached for details. Any help would be greatly appreciated!
Thank you!
BrianCopy of Incentive Doc.xlsx
Hello! I am finishing up my incentive formula and stuck on issue. See attached for details. Any help would be greatly appreciated!
Thank you!
BrianCopy of Incentive Doc.xlsx
bhager,
The syntax for IF statements is fairly straightforward: IF(logical test, [value if (logical test is) true], [value if (logical test is) false].
To achieve (from your spreadhseet) "If yes, then 10% of C5 (where C5 can be any number), if no then $0", your statement would look/read like this:
IF E13="yes", return C5 * 10%; otherwise return $0.
In Excel, this equates to:
Please Login or Register to view this content.
Hope this helps.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks