if calculations?

  • Thread starter Thread starter altottenham
  • Start date Start date
A

altottenham

hello

problem

need D11 in me spreadsheet to look in D7toD10 to see if it is showin
YES if it shows YES then i need to do a calculation of 5.50*44, if th
cell shows N/A i need D11 to show 0.

cheers for your hel
 
Hi
do you want all cells in the range D7:D10 to show yes. If this is true
try in D11
=IF(COUNTIF(D7:D10,"yes")=4,"YES","N/A")
 
Do you mean any cell having YES?

If so,

=IF(COUNTIF(D7:D10,"Yes")>0,5.50*44,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Make this
=IF(COUNTIF(D7:D10,"yes")=4,5.50 * 44,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Frank Kabel said:
Hi
do you want all cells in the range D7:D10 to show yes. If this is true
try in D11
=IF(COUNTIF(D7:D10,"yes")=4,"YES","N/A")

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag news:[email protected]...
Click to expand...
 
If the existence of a single YES in D7:D10 is suffient...

In D11 enter:

=ISNUMBER(MATCH("YES",D7:D10,0))*5.50*44
 
I am mounting a campaign to rid workbooks of unnecessary IFs <grin>
Here is my solution =(COUNTIF(D7:D10,"yes")>0)*5.5*44

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


Bob Phillips said:
Do you mean any cell having YES?

If so,

=IF(COUNTIF(D7:D10,"Yes")>0,5.50*44,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
I'll join the campaign<g>

Bob

Bernard Liengme said:
I am mounting a campaign to rid workbooks of unnecessary IFs <grin>
Here is my solution =(COUNTIF(D7:D10,"yes")>0)*5.5*44
Click to expand...
 
Back
Top