Hello,
I would like to do the following: deduct the values from column F from column E, but in case, a cell from
column F contains #N/A, return the comment MISSING. I tried nesting an IFNA in an IF like it's shown in the below picture,
but i get the error "You've entered too few arguments for this function." Could you help me out with this please?
Thank you.
Capture.JPG
this should do it.
Formula:
Please Login or Register to view this content.
The IFNA value_if_NA must be contained with the IFNA brackets. You simply have (F2), if you make it IFNA(F2,"Missing") Then your original IF condition would be looking to check whether something was "MISSING" or not
Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back
Please also mark your thread as solved once it has been.
Still unclear to me, how the complete formula should look. Could you help me out with that?
The (F2) was originally in the bracket. Tried with your formula also on the IFNA, but then it's unclear what i should input on the IF value_if_true.
You don't need the IF statement because you're already telling the cell what to do if the result is #N/A (which it will be if either E2 or F2 contain #N/A
An IF statement is asking a question.
So IF A = A, TRUE, FALSE
Using IFNA(E2-F2,"MISSING") you're essentially asking IF THE RESULT OF E2-F2 IS #N/A, TRUE = "MISSING", FALSE = E2-F2
How simple and I did not figure it out. Thank you Dave!
No worries, we're all learningOriginally Posted by Rocksteady
If that's the thread solved please mark it as such and feel free to leave feedback if you think it's deserved.
btw.
IFNA function
Applies To: Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011
Not available in 2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks