Excel formula assistance - two if/thens

squeakums

Well-known Member
Joined
May 15, 2007
Messages
665
I have this formula, but I'm trying to write into it:

=IF(F4<=199, 0, 10)

also, if f4 = "Chris" then "N/A"

Help please?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,702
Office Version
2007
Platform
Windows
Specifically with "Chris" or with any word, then try this:

=IF(ISERR(F4+0),"N/A",IF(F4<=199,0,10))
 

Watch MrExcel Video

Forum statistics

Threads
1,098,992
Messages
5,465,869
Members
406,452
Latest member
GroupGoal

This Week's Hot Topics

Top