I have the following formula -:
=IF(H6>0,D6*K6,0)
I want to include ISNA within this to get rid of #N/A's. I use them on vlookups but can't figure it out on this one. (The #N/A's stem from the K6 in the formula)
Any help appreciated.
How about:
Cheers,=IF(OR(ISNA(D6*K6),H6<=0),0,D6*K6)
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
Cheers, thanks very much.Originally Posted by ConneXionLost
SOLVED!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks