New
#1
Anyone any good at spreadsheet formulas??
Hi Guys
I am reasonably able to do formulas but one I need is foxing me, I will try to show example.
Cell A Cell B Cell x (profit)
100 150 50%
I am displaying that A has made a 50% profit, but B will change from time to time so when B changes, I want X to show the new %. I believe it should be something like >>
sum( B - A = 50 /100