Excel formula assistance - two if/thens

squeakums

Well-known Member
Joined
May 15, 2007
Messages
657
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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,096
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,095,388
Messages
5,444,183
Members
405,271
Latest member
Kjtakke

This Week's Hot Topics

Top