Thread: Returning 100%
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default Returning 100%
Cancel that request.

For those interested, I worked out the following

=IF(C4=0,0,IF(C4B4,(C4*100),PRODUCT(C4,1/B4)*100))

Cheers
Mick.


Reply With QuoteReply With Quote