answersLogoWhite

0

Assuming the At Fault claims are in E4 and Rating is in F4 then your formula in G4 would be:

=If(And(E4>1,F4>2),"Yes","No")

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you enter the IF function to display the message Significant for any percent greater than 20 percent Otherwise display the message ok in Excel 2007?

Say the value is in B3, then the formula would be: =IF(B3>20%,"Significant","ok")


The voltmeter has greater accuracy when measuring what kind of current?

A voltmeter has greater accuracy when measuring direct current. This kind of current is constant unlike alternating current which has constant fluctuations.


Which has greater salinity a deep current or surface current?

wat


Is the current greater or less?

Yes.


What Formula for calculating the charging time of vrla batteries under varying load conditions?

For Panasonic Vrla batteries the formula isWhen current charge is 0.25ca or greater Tch=Cdis/I+(3to5)#When current is below 0.25caTch=Cdis/I+(6to10)Tch =charging timeCdis =amount of dischargeI=initial charge current (amps)This time does not include Trickle charging .Answered byNachiket


Is it true that for the same resistance the greater the voltage the greater the current?

true


What happen to the current when the voltage is greater than or equal to 6 volts?

The current is greater than or equal to (6) divided by (the effective resistance of the circuit).


Is electrical current greater before or after light bulb?

Electrical current is equal throughout a series circuit.


When is formula 1 in india?

Formula 1 is organised by Jaypee group in Greater noida. it is organised in october end.


What is rack policy?

In a travel agency, any conscious decision regarding how to display suppliers' brochures on a display stand, or "rack." For example, an agency may decide not to display the brochures of certain suppliers or give certain destinations greater exposure.


Suppose youre given the formula R s 2t If you know that s is three times greater than t how could you rewrite the formula?

You can rewrite the formula as R = 3t^2. Since s is three times greater than t, you can substitute 3t for s in the formula.


What has the greater current in the diodes bridge rectifier circuit or full-wave rectifier circuit?

They both have the same current.