Formula that will look at different rows for calculation

Board Regular
Hello,

I need assistance in creating a formula that will look at different criteria for a calculation:

Cell:
A1= Primary Date1
A2= Desc. of Primary Price1
A3=Desc. of Alternate Price1
A4= Desc. of different Alternate Price1

A5= Different Primary Date2
A6= Desc. of Primary Price2
A7=Desc. of Alternate Price2

B1= Blank cell (intentional)
B2= Primary Price1
B3= Alternate Price1
B4= Blank cell > no data availabe from different alternate price1 source

B5= Blank cell (intentional)
B6= Primary Price2
B7= Alternate Price2

I need a formula that will do the following:

In cell C3>
- Based on the primary date; calculate the difference between the Primary Price1 and the Alternate Price1.

In cell C4>
-Calculate the difference between the Primary Price1 and the different Alternate Price1. The output for this calculation should be a blank as there was no data available in for the Alternate Price1.

In cells C6 and C7, the calculations would be the same as cells C3 and C4, but they would be based on the different primary date2.

I hope I was able to explain this in detail.

Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

footej

New Member
C3 = "=IF(ISBLANK(B3),"",B\$2-B3)"
C4 = "=IF(ISBLANK(B4),"",B\$2-B4)"
C6 = "=IF(ISBLANK(B6),"",B\$2-B6)"
C7 = "=IF(ISBLANK(B7),"",B\$2-B7)"

Board Regular
Hello Footej,

That worked!! Thank you very much for the assistance.

Replies
3
Views
178
Replies
6
Views
670
Replies
18
Views
8K
Replies
6
Views
210
Replies
7
Views
825

1,190,603
Messages
5,981,890
Members
439,743
Latest member
KatieO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back