I need a solution for this situtaion!
Iam using a french version of excel2003!
I have #DIV/0! in P24 (i.e an error value)
So I need to check in Q24 such that if (P24=#DIV/0!,0,P24)
I need to have a logical formula for this one!
Thanks for your time!
regards
Taniks
Last edited by taniks; 12-16-2008 at 05:25 AM.
In English =if(iserror(p24),0,P24)
In French =si(esterreur(p24),0,P24)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Thanks for your quick reply!
I had the solution for my problem!
thanks for ur time!
regards
Taniks
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
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks