LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,344
Default NEED A FORMULA

Hi,

That depends on what you are really asking:

If you are simply checking for the letter "H" in the cell then the formula
would be
=IF(A1="h",A3-A4,"")

If you are trying to determine if the letter "H" is anywhere in the contents
of cell A1 then
=IF(ISERR(FIND("h",A1)),"",A3-A4)

There is also a way to do it with the SUMIF function.

--
Thanks,
Shane Devenshire


"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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"