fintansmith
New Member
- Joined
- Dec 20, 2021
- Messages
- 3
- Office Version
- 2013
- Platform
- Windows
Hi,
Im not very competent on VBA but really need a macro to insert a column at GB with the below formula -
=IF((IF(AJ4="CLOSED",BA4,IF(BE4<BP4,0,IF((AY4+AV4)>BQ4,BA4,BA4-(BQ4-(AY4+AV4)))))-BR4)>=0,(IF(AJ4="CLOSED",BA4,IF(BE4<BP4,0,IF((AY4+AV4)>BQ4,BA4,BA4-(BQ4-(AY4+AV4)))))-BR4),IF(AJ4="CLOSED",0,IF((AY4+AV4)>BR4,BA4+(0-BR4),0)))
Could anyone please give me a hand? Really struggling.
P.s the formula is above is row 4 but on row 5 all cells should be 5 etc.
Many thanks
Im not very competent on VBA but really need a macro to insert a column at GB with the below formula -
=IF((IF(AJ4="CLOSED",BA4,IF(BE4<BP4,0,IF((AY4+AV4)>BQ4,BA4,BA4-(BQ4-(AY4+AV4)))))-BR4)>=0,(IF(AJ4="CLOSED",BA4,IF(BE4<BP4,0,IF((AY4+AV4)>BQ4,BA4,BA4-(BQ4-(AY4+AV4)))))-BR4),IF(AJ4="CLOSED",0,IF((AY4+AV4)>BR4,BA4+(0-BR4),0)))
Could anyone please give me a hand? Really struggling.
P.s the formula is above is row 4 but on row 5 all cells should be 5 etc.
Many thanks