I have two cells that i need to average unless one cell has N/A in it. Then I want it to just say N/A. Currently the following formula will average and will input N/A only if both cells have N/A. If one has N/A it just inputs the numeric value of the other cell.
=IF(($B27="N/A")*OR($C27="N/A"),"N/A",AVERAGE($B27:$C27))
So if B or C have N/A then I want D to say N/A.
Last edited by CityInspector; 08-08-2013 at 04:16 PM.
Do you mean?
=IF(OR($B27="N/A",$C27="N/A"),"N/A",AVERAGE($B27:$C27))
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.
or maybe...
=if(count($B27:$C27)<>counta(),"N/A",average($B27:$C27))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, that worked perfectly. For some reason i didnt think to put the "Or" first.Originally Posted by Fotis1991
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks