Forum Discussion
dithering a choice in excel
I have self taught myself many functions in Excel but am struggling with one last task I would like to complete. I have a worksheet I have created that have four columns to choose from 1, 2, 3 and N...
Hi,
Let's assume you have the following "cell addresses" for your first four columns: A1 for col. 1, B1 for col. 2, C1 for col. 3, and D1 for col. 4 (NA col.).
Enter the following in cell A1: AT IF(A1>0, B1 =0,C1=0)
Enter the following in cell B1: AT IF(B1>0, A1=0,C1=0)
Enter the following in cell C1: AT IF (C1>0, A1-0, B1=0)
You would, of course, "copy down" the formulas through the rest of the rows.
Do not enter anything in the NA cell.
See if it works. Good luck. l
thanks!