Gettingbetter15
New Member
- Joined
- Oct 20, 2016
- Messages
- 20
Good morning!
I'm so grateful this website is here! I hope someone out there can help me. Based on the table below, I want to create an if/then statement in the cell to the right of the Total cell subtracting all Orange values from Apple values. I know this can be done, just don't know how. Can someone help me please? I can't wait to hear from you and thank you so very much!
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]113[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm so grateful this website is here! I hope someone out there can help me. Based on the table below, I want to create an if/then statement in the cell to the right of the Total cell subtracting all Orange values from Apple values. I know this can be done, just don't know how. Can someone help me please? I can't wait to hear from you and thank you so very much!
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]113[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]