If functions

  • Thread starter Thread starter matthewa
  • Start date Start date
M

matthewa

Hi I know this might sound a bit daft but I would appreciate any help a
all.

I am trying to use a function in a cell whereas it states that if th
contents in a cell, say B11 = the same as B3 or B4 then it calculate
another IF formula. at the moment I have something like:

IF(B11=B3ORB4,24)

If this is stupid please don't be afraid to tell me.

Thanks loads in advance
 
Hi Matthew

there's no such thing as a stupid question - none of us woke up one day
knowing all this stuff :)

try
=IF(OR(B11=B3,B11=B4),what happens if either of them are true, what happens
if neither of them are true)

Regards
JulieD
 
Thanks your a star
-----Original Message-----
=IF(OR(B11=B3,B11=B4),24,Else_Whatever's_In_Here)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.608 / Virus Database: 388 - Release Date: 03/03/2004


.
Click to expand...
 
Thanks that is great and all I need your a star
-----Original Message-----
Hi Matthew

there's no such thing as a stupid question - none of us woke up one day
knowing all this stuff :)

try
=IF(OR(B11=B3,B11=B4),what happens if either of them are true, what happens
if neither of them are true)

Regards
JulieD





.
Click to expand...
 
Matthew,

Answering as specified

=IF(OR(B11=B3,B11=B4),24)

but you should at least include an option if it doesn't match

=IF(OR(B11=B3,B11==B4),24, some_other_number).

You also said some other formula. If you meant this, this would be like

=IF(OR(B11=B3,B11==B4),24, IF(some_Other_condition, A,B))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top