Question posted 2014 · +21 upvotes
I need help on my Excel sheet. How can I declare the following IF condition properly?
if A1 = "n/a" then C1 = B1
else if A1 != "n/a" or has value(int) then C1 = A1*B1
Accepted answer +41 upvotes
Input the following formula in C1:
=IF(ISNA(A1),B1,A1*B1)
Screenshots:
When #N/A:
When not #N/A:
Let us know if this helps.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 4%.