Excel Formula

[NITA]

I am trying to create a formula in a speadsheet for the
following:

If cell "C" is true and cell "G" is blank then leave
cell "H" blank otherwise give me the max of cell "B,"F"
or "G" in cell "H."


Thank you,

Nita

 

[Peo Sjoblom]

One way

=IF(AND(C1=TRUE,G1=""),"",MAX(B1,F1,G1))

 

[Biff]

Hi Nita,

Try this:

=IF(AND(C1="TRUE",G1="","",MAX(B1,F1,G1))

Biff

 

[JMay]

" " 's around the TRUE produce the wrong results...

s/b --->>> =IF(AND(C1=TRUE,G1="","",MAX(B1,F1,G1))

 

[Biff]

Ooops, forgot a ")"

=IF(AND(C1="TRUE",G1=""),"",MAX(B1,F1,G1))

That's better!

 

[Biff]

Hi JMay,

Only if it's a Boolean. If it's "TEXT", you need them. But
that wasn't made clear by the OP.

Biff

 

[JMay]

Got to consider all the possibilities, as TRUE can take two forms;
Thanks,
JMay