daisypetals313
asked on
IF/Then statement when column equals zero
Hello. What would be the formula so that Column C (in the attached file) would multiply the result of the formula currently in Column C only when the value of Column A is zero?
sample.xlsx
sample.xlsx
=IF(A2=0,SUM(A2-B2),"")
Two questions...
1. Multiply by what? The value in column C by the value in column C, i.e. the square of the value in column C?
2. What do you want to return if the vale is not zero?
The below formula assumes you wish to multiply the value in column C by 2 if the value in column A is zero. If the value in column A is not zero, return zero.
=IF(A2=0, C2*2, 0)
1. Multiply by what? The value in column C by the value in column C, i.e. the square of the value in column C?
2. What do you want to return if the vale is not zero?
The below formula assumes you wish to multiply the value in column C by 2 if the value in column A is zero. If the value in column A is not zero, return zero.
=IF(A2=0, C2*2, 0)
=IF(A2,"",A2-B2)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 500 points for Wayne Taylor (webtubbs)'s comment #a40892794
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for Wayne Taylor (webtubbs)'s comment #a40892794
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Yes that link is it. Thanks! Not homework, work actually.