I hope you can help.
What I am trying to achieve is this. On my workbook I have many sheets. The sheet I want my answer on is Vetplan_ROI_V6. and I want the value to appear in column AC
The Formula I have type in AC is something like the below. But I am not getting the correct result. On sheet Vetplan_ROI_V6. IF Cell H2 = "57514" and Cell AB2 = "XLVets" then go to sheet named ROI RUBU Schema get the value in Cell G96 and multiply the figure in Vetplan_ROI_V6 Cell M2 by the G96 value on ROI RUBU Schema and return me a numerical value.
The formula I have tried is =IF(AND(H2="57514",AB2="XLVets",M2*'ROI RUBU Schema'!G96))
I believe I should get a numerical result on line 400 from pic 1 but I just get FALSE
I am sure it something simple. Any and all help is greatly appreciated
Pic 1


Aucun commentaire:
Enregistrer un commentaire