none
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

Answers

  • trini-Man,

    This looks like basically the same question I answered for you a couple weeks ago (http://social.msdn.microsoft.com/Forums/en-US/projectprofessional2010general/thread/ea7e6d45-01c8-4c6a-a735-9512619293eb). 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")?

    John



    • 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