What have you done so far and where are you stuck? Do you want VBA to write the formula to a cell or do you want to write a function that mimics the behaviour?
- FunThomas
AS6AT6 isn't a cell reference. Do you mean AS6:AT6 which will return two values?
- Darren Bartrup-Cook
Range("A1").Formula2 = "=IF(BC5=""YES"",ROUND(AS6:AT6,2)+BD5,ROUND(AS6:AT6,2))"
- Darren Bartrup-Cook
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkRead more
AS6AT6isn't a cell reference. Do you meanAS6:AT6which will return two values? - Darren Bartrup-CookRange("A1").Formula2 = "=IF(BC5=""YES"",ROUND(AS6:AT6,2)+BD5,ROUND(AS6:AT6,2))"- Darren Bartrup-Cook