Formula that will look at different rows for calculation

[maldonadocj]

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.

Thank you in advance for your assistance.

 

[footej]

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)"

 

[maldonadocj]

Hello Footej,

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