Hi everyone,
I know this must be a simple formula but I cant get it to work
I am trying to translate this into a formula: If DA9 has "X" the "" , if not then CY9>49%,"X",""
I tried : IF(OR(DA9="X",""),IF(CY9>49%,"X","")) tried with AND but no luck
Canyou help me?
Perhaps....
=IF(DA9="X","",IF(CY9>49%,"X",""))
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.
Thks so much!!
You are welcome and thanks for the reb*.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks