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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,773
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,099,461
Messages
5,468,781
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top