S
Sudip_inn
Guest
in my apps excel formula saved in db. which i need to change by c# code
My formula looks like (AM453+AM468+AM483+AM498) which should be change like below one.
IF(AM453="","",IF(AM468="","",IF(AM483="","",IF(AM498="","",(AM453+AM468+AM483+AM498))))
AM468 or AM453 etc are cell address in excel.
My formula also may look like (AM453+AM468+(AM483/AM498)) OR (AM453+AM468-(AM483*AM498))
actually my formula could be anything which i need to parse and inject IF cell address is blank then return blank this way
IF(AM453="","",IF(AM468="","",IF(AM483="","",IF(AM498="","",(AM453+AM468+AM483+AM498))))
please share some routine which i can use to pick cell address one by one from any kind of formula. after pickup cell address i need to enter this one in formula like IF(AM453="","",.......)
please guide me how to achieve this with sample routine. if possible share a sample routine. thanks
Continue reading...
My formula looks like (AM453+AM468+AM483+AM498) which should be change like below one.
IF(AM453="","",IF(AM468="","",IF(AM483="","",IF(AM498="","",(AM453+AM468+AM483+AM498))))
AM468 or AM453 etc are cell address in excel.
My formula also may look like (AM453+AM468+(AM483/AM498)) OR (AM453+AM468-(AM483*AM498))
actually my formula could be anything which i need to parse and inject IF cell address is blank then return blank this way
IF(AM453="","",IF(AM468="","",IF(AM483="","",IF(AM498="","",(AM453+AM468+AM483+AM498))))
please share some routine which i can use to pick cell address one by one from any kind of formula. after pickup cell address i need to enter this one in formula like IF(AM453="","",.......)
please guide me how to achieve this with sample routine. if possible share a sample routine. thanks
Continue reading...