openmolecules.org Forum: Functionality » Averaging Values in three columns

Home » DataWarrior » Functionality » Averaging Values in three columns

Show: Today's Messages :: Polls :: Message Navigator

Re: Averaging Values in three columns [message #1042 is a reply to message #1040]

Sat, 15 August 2020 13:40

thomas
Messages: 747
Registered: June 2014

Senior Member

it is a little longer, but this would work:

(if(isempty(A),0,A)+if(isempty(B),0,B)+if(isempty(C),0,C))/
(if(isempty(A),0,1)+if(isempty(B),0,1)+if(isempty(C),0,1))

[Updated on: Sat, 15 August 2020 13:41]

Report message to a moderator

[Message index]

		Averaging Values in three columns By: ELFritzen on Fri, 14 August 2020 23:19
		Re: Averaging Values in three columns By: thomas on Sat, 15 August 2020 13:40
		Re: Averaging Values in three columns By: ELFritzen on Sun, 16 August 2020 19:19
		Re: Averaging Values in three columns By: ELFritzen on Sun, 16 August 2020 21:15
		Re: Averaging Values in three columns By: thomas on Mon, 17 August 2020 13:54
		Re: Averaging Values in three columns By: ELFritzen on Mon, 17 August 2020 15:57

Previous Topic:	Tagging Data to a Particular Assay
Next Topic:	Smiles to Structure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 09 00:35:01 CEST 2026

Total time taken to generate the page: 0.00421 seconds