Duplicating a result to all aother cells formula RRS feed

  • Question

  • Hello, how would I have the same result displayed for all other cells? Not sure ID 0? Right now it displays the result in the cell in ID 0 and all other have $0.00. I want all the others to have the same result.

    IIf([ID]=0,[Budget Cost]-[Budget to Date Cost],0)

    Thank you

    Friday, March 1, 2013 7:11 PM


  • trini-Man,

    This looks like basically the same question I answered for you a couple weeks ago ( How is it different this time (i.e. you'll have to use the macro I gave you previously with a little editing to pick up whatever field contains the "Budget to Date Cost")?


    • Edited by John - Project Saturday, March 2, 2013 4:58 PM
    • Marked as answer by trini_man Tuesday, March 12, 2013 4:16 PM
    Friday, March 1, 2013 8:49 PM