answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Excel 2007 Create the formula in G4 to display the text Yes if the number of Atfault claims is greater than 1 and the current rating is greater than 2?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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


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 the current greater or less?

Yes.


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


When is formula 1 in india?

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


Is electrical current greater before or after light bulb?

Electrical current is equal throughout a series circuit.


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.


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

They both have the same current.


What is overload current?

A current greater than which a circuit is designed to carry , may melt wires or damage elements of the circuit.This is known as overloading of current.