Excel formula assistance - two if/thens

squeakums

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
9,607
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))
 

Forum statistics

Threads
1,085,016
Messages
5,381,238
Members
401,723
Latest member
har0ld137

Some videos you may like

This Week's Hot Topics

Top