I am looking for a formula based on the following.
Cell A1 has any number from 0 through to 360.
Cell A2 has any number from 0 through to 360.
Cells C1 and D1 are to return results based on the following proceedure.
360 subtract (A1+A2) and subtract 360 if [360 subtract (A1+A2)] is greater than or equal to 360 and this to return the numerical result in cell C1 with the letter w in cell D1, and if Cell C1 is greater than or equal to 180, then 360 subtract the tesult in Cell C1 and Cell D1 to return the letter e.
Look forward to getting help with this.
Thank You.
Cell A1 has any number from 0 through to 360.
Cell A2 has any number from 0 through to 360.
Cells C1 and D1 are to return results based on the following proceedure.
360 subtract (A1+A2) and subtract 360 if [360 subtract (A1+A2)] is greater than or equal to 360 and this to return the numerical result in cell C1 with the letter w in cell D1, and if Cell C1 is greater than or equal to 180, then 360 subtract the tesult in Cell C1 and Cell D1 to return the letter e.
Look forward to getting help with this.
Thank You.