LinkBack URL
About LinkBacks
if cell a2 = dave and b2 = accept then divide c2/d2*100 and I want this to run on every row in the colum so a2:a132 etc
=IF(AND(A2="dave",B2="accept"),C2/D2*100"",)
And copy down to row 132. The cell references will auto-adjust.
Regards
if cell a2 = dave and b2 = accept then divide c2/d2*100 and I want this to run on every row in the colum so a2:a132 etc
=IF(AND(A2="dave",B2="accept"),C2/D2*100"",)
And copy down to row 132. The cell references will auto-adjust.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks