This is my first time posting something here, hoping to get some help with my worksheet.
I've tried several different formuals and combinations, however keeps resulting in errors.
Here's what I want:
If the header from a table matches the value of column A in a specific table then the value in column E of the same table needs to be divided by the following:
if a value from column M matches a value from column A in the corresponding table then the value in column E of the same table
Have tried the following formulas:
- =IF(Table25[Patio roof beams]=M5;IF(Table1[Delivery beds]=N4;Table1[Volume]/Table25[Volume]![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
This one returns with #VALUE !
- =QUOTIENT(IF(Table1[Delivery beds]=P4;Table1[Volume]
;IF(Table25[Patio roof beams]=M5;Table25[Volume]
)
This one returns with #N/A
Would greatly appreciate any help.
I've tried several different formuals and combinations, however keeps resulting in errors.
Here's what I want:
If the header from a table matches the value of column A in a specific table then the value in column E of the same table needs to be divided by the following:
if a value from column M matches a value from column A in the corresponding table then the value in column E of the same table
Have tried the following formulas:
- =IF(Table25[Patio roof beams]=M5;IF(Table1[Delivery beds]=N4;Table1[Volume]/Table25[Volume]
This one returns with #VALUE !
- =QUOTIENT(IF(Table1[Delivery beds]=P4;Table1[Volume]
This one returns with #N/A
Would greatly appreciate any help.