Excel Doubt - IF Formula
Solved/Closed
Hi,
Im stuck in an if question.
I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I want it to SUM the number in the first column and a number in the second column associated with the word "yes".
Is it possible?
For example the sum with 7(first column) with 5 (second column associated to "yes") which will give 12 in the third column.
Thanks,
Im stuck in an if question.
I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I want it to SUM the number in the first column and a number in the second column associated with the word "yes".
Is it possible?
For example the sum with 7(first column) with 5 (second column associated to "yes") which will give 12 in the third column.
Thanks,
Related:
- Excel Doubt - IF Formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 17, 2016 at 03:42 AM
Apr 17, 2016 at 03:42 AM
Hi,
Good Question, lets see how to do it:
A1 - 7
B1 - 5
C1 - Yes
D1 - =IF(C1="Yes",A1+B1,)
Drag the Formula in D1 all the way to the bottom of the sheet (till there is data).
Hope this helps.
Good Question, lets see how to do it:
A1 - 7
B1 - 5
C1 - Yes
D1 - =IF(C1="Yes",A1+B1,)
Drag the Formula in D1 all the way to the bottom of the sheet (till there is data).
Hope this helps.
histriongg
Posts
1
Registration date
Friday April 29, 2016
Status
Member
Last seen
April 29, 2016
Apr 29, 2016 at 08:26 AM
Apr 29, 2016 at 08:26 AM
Completing Zohaib's answer, I would suggest
D1 - =IF(C1="Yes",A1+B1,A1)
assuming that if we have no "YES" then we just want to copy A1 over.
Also, if you want to keep the current file data, with the first value in column A, then the "YES" in column B, then
in F1 type "5"
in the Formulas menu / Define name set the name "Tax" for cell F1
in C1 enter
C1 - =IF(B1="Yes",A1+Tax,A1)
D1 - =IF(C1="Yes",A1+B1,A1)
assuming that if we have no "YES" then we just want to copy A1 over.
Also, if you want to keep the current file data, with the first value in column A, then the "YES" in column B, then
in F1 type "5"
in the Formulas menu / Define name set the name "Tax" for cell F1
in C1 enter
C1 - =IF(B1="Yes",A1+Tax,A1)