Thread: NEED A FORMULA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default NEED A FORMULA

Vague, but perhaps this, in say B1:
=IF(ISNUMBER(FIND("H",A1)),A3-A4,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"gantz4" wrote:
I need some help. I am a beginner level excel user. I need to write a basic
formula that has 2 conditions. I am trying to count the numer of times H
(meaning home) appears in a cell, lets say A1, if it does then what is the
difference between cells A3 and A4 (A3-A4). Could someone please help me,
thank you.