Hi. I am new to this forum and not very new to Excel (not in depth)
I have to perform a calculation for three cells by conditional calculation. so here is the scenario
Column Name: Total Area (Cell Address: A2)
Column Name: Remaining Area (Cell Address: B2)
Column Name: Allotted Area (Cell Address: C2)
As per snap shot
Capture.PNG
Now when I enter a digit in the A2 And B2, It subtract and put the result in C2. And if I enter a digit in the A2 And C2, It subtract and put the result in B2.
Can Anyone guide me how to perform this task.
Bookmarks