HI,
Please somebody help me on the attached file of KPI measurement.
formula in F5,
=IF(AND($D5<7),"ACHIEVED","NOT ACHIEVED")
Danish is not process any PO, he should be N/A.
how to write the both function.
Best Regards
Mr. Kaff
HI,
Please somebody help me on the attached file of KPI measurement.
formula in F5,
=IF(AND($D5<7),"ACHIEVED","NOT ACHIEVED")
Danish is not process any PO, he should be N/A.
how to write the both function.
Best Regards
Mr. Kaff
Maybe
=IF(AND($D5<7,$D5<>0),"ACHIEVED","NOT ACHIEVED")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis,
thanks but it doesnt work.
Why?...........
i want to putN/Afor Danish , he doesnt processed of any PO.
May be this...
On F5 cell
Formula:Please Login or Register to view this content.
Drag it down.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Like this?
=IF($D5=0,"#N/A",IF(AND($D5<7),"ACHIEVED","NOT ACHIEVED"))
On F5 cell
Formula:Please Login or Register to view this content.
mohdkaffi,
should work for you - see attached.Please Login or Register to view this content.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
thanks all. it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks