Thread: Find text, then calculate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Find text, then calculate
Hi,
With your data as given, try the following into E2 and copy down.

=IF(ISNUMBER(FIND("Gal",A2)),D2*LEFT(A2, FIND(" ",A2)-1),D2*LEFT(A2, FIND("
",A2)-1)/4)

Regards - Dave.
Reply With QuoteReply With Quote