PDA

View Full Version : VBA Procedure for nested if statement.



_google
02-08-2013, 12:25 PM
Col-A Col-B Col-C Col-D Col-E Col-F Col-G Col-H Col-I Col-J Col-K Col-H Col-I Col-J Col-K Col-L Col-M Col-N Col-O
IF(F="",C&D&O,IF(H="",C&F&O,IF(J="",C&F&G&O,"!")))

Hi Rick,

I am novice to VBA , and tried to create procedure for above formula without success. Pl help to give me procedure .. not function to run the formula output as desired . Alphabet in the formula refer to the excel columns based on which i want output to come in column A cells.

Excel Fox
02-08-2013, 10:16 PM
Cross posted at VBA Statement for nested if-Fomula (http://www.mrexcel.com/forum/excel-questions/684367-visual-basic-applications-statement-nested-if-fomula.html)







https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA (https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA)