Blanket Formula for revenue estimating
Hi,
I'm trying to find a way to estimate revenue, I posted earlier today about a Hypothetical fruit shop so i'm going to continue with that.
Earlier someone helped me an amazing formula to read and return Values from a purchase ledger. This worked and was able to return my values, but now I cant figure out how to get it all to calculate the actual $ amount.
For my earlier example i used
Johnny bought 5x apples granny smith 3x oranges 3x strawberry
Lisa bought 1x pineapple Large fresh 2x blueberry packaged 1x grape bunch large
Kerry bought 9 x apple loose 1 x Banana bunch 5x kiwi
I now have a sheet where i can copy and paste my purchase ledger and it breaks it down
What i can't figure out is how to get it all to calculate without having to do loads and loads of tedious work. I need it to read Apples, then than the quantity and give me the result. So lets say an Apple is 0.50c then i want it to Find Apples, find the value and times by 3 to give me $1.50. Hopefully this makes sense as its quite long winded
[link] [comments]
Want to read more?
Check out the full article on the original site