I need help with 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
Input the following formula in C1:
When not #N/A:
I hope this helps you.
I am also working as an Oracle ...READ MORE
Hi so basically, create an adjacent column ...READ MORE
In Excel, hiding formulae is a feature ...READ MORE
Here is a really excellent tutorial on ...READ MORE
Hello, yes u can find your birthdate using ...READ MORE
Hi To Calculate the date, we can ...READ MORE
I having a Excel sheet with 1 ...READ MORE
In this case, you can use nested ...READ MORE
What about using mid() to see if ...READ MORE
You can enter the following formula in ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.