hi Nebu, how do i copy these formulas to another file as they have a circular reference. It does not work when i copy and paste the whole thing in a new file.
Help: Multiple functions in one cell
- Thread starter alibilal
- Start date
Ok .. let me organize the file and forward that to you .. but just by the way .. is there not an easier way to make this work ?well , you have to follow the logic I have applied in the formula and try to replicate it , without seeing your other file I won't be able to say why there is a circular reference....
Hi Nebu, I have uploaded the file. I am sure there would be a better way to do it horizontally .. till i design a horizontal layout, i believe this should work.well , you have to follow the logic I have applied in the formula and try to replicate it , without seeing your other file I won't be able to say why there is a circular reference....
Attachments
Hi .. when you change the values in "C" and "D", the formulas start giving wrong out comes .. I have marked two in the file for your reference.Hi
Please find the attached , have also added a conditional formatting to shade the Saturdays...
Attachments
You are right and thanks for fixing the other one. I hope it works when I copy the the formulas to complete sheetHi
Please find the attached and the explanation....
Another issue .. if the Value in "C=0 and D=0" ... why do we get all different values in "E", "F" and "G" ?Hi
Please find the attached and the explanation....