I am trying to automate filling of adjacent cells with dollar amounts when a certain key is typed in. A1 = Screening, B1 =$5,000.00 but for many keys.
I used this code: =IF(ISERROR(SEARCH("*Screening*",F3,3)),IF(ISERROR(SEARCH("*Week 1*",F3,3)),IF(ISERROR(SEARCH("*Week 3*",A1,1)),IF(ISERROR(SEARCH("*Week 5*",F3,3)),IF(ISERROR(SEARCH("*Week 9*",F3,3)),IF(ISERROR(SEARCH("*Week 13*",F3,3)),IF(ISERROR("*Week 16 (Pre-Surgical)*",F3,3)),IF(ISERROR(SEARCH("*Surgery*",F3,3)),IF(ISERROR(SEARCH("*Post Surgery*",F3,3)),"","$1,108.75"),"$26.88"),"$2,151.25"),"$842.50"),"$1,839.24"),"$952.20"),"$941.25"),"$941.25"),"$2608.75")
I received this error: "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format.
HELP IS MUCH APPRECIATED. Picture is attached.
Bookmarks