Rewriting a formula

November 27, 2010 at 12:05:24
Specs: Windows Vista
Is there a way to write this formula but not to use max or min before?

=IF(MAX($C$1:$C$6)=C1,"Max",IF(MIN($C$1:$C$6)

Maybe something like this =if($C$1:$C$6)max=C1,"IF($C$1:$C$6)min. Im not sure if this would work but something where Max and Min would be after ($C$1:$C$6). Thank you. Hopefully im not to confusing.


See More: Rewriting a formula

Report •

#1
November 27, 2010 at 12:31:57
Before we even address your question about rewriting your formula, we should point out that the formula you posted isn't even a complete formula.

Then, assuming you can fix your formula so that it actually works, I'd like you to tell us why you want to rewrite it.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
November 27, 2010 at 12:35:37
This is the correct formula. Half of it didn't cope when I copied it.

=IF(MAX($C$1:$C$6)=C1,"Max",IF(MIN($C$1:$C$6)=C1,"MIN",""))

I want to rewrite it because there is a shorter way of writing this formula


Report •

#3
November 27, 2010 at 12:46:15
re: "because there is a shorter way of writing this formula"

Who says there's a shorter way?

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

Related Solutions

#4
November 27, 2010 at 12:54:47
Thank you for your help

Report •

Ask Question