Is this doable?
Let's say that i have 5,10,15 and 10 HotDogs, 25 HotDogs and 50 HotDogs stated in other 3 cells. I know i could do it cell by cell, but I'd like to do it with a shorter formula (there will be more values than just 3 in an array).![]()
=A1*left(A2,2)
Thanks
does the job but only for the first couple of cells in the array - it ignores all other.![]()
={AZ4*BA4+(BB4:BF4*LEFT(BB3:BF3,2))}
Bookmarks