Hi I am working with two currencies so I made a formula so that the cell can recognize what currency it is...
=IF(L9>0,SI(CELL("format",L9)="C2",Sheet1!$B$25,Sheet1!$B$26))
Maybe someone knows a better formulta?
thanks
THis says if this number is greater than zero, than have to search the format and their are two options..
thanks
This now is not working
=IF(L9>0,SI(CELL("format",L9)="C2",Sheet1!$B$25,Sheet1!$B$26))
Maybe someone knows a better formulta?
thanks
THis says if this number is greater than zero, than have to search the format and their are two options..
thanks
This now is not working