Excel Question

[ilovetheusers]

This seems like a simple question but it's not from what I can see.

I want to have a field display an X of anything in 4 other fields is a number above 70.

I.E. - If E2 or F2 or G2 or H2 are > 70 make an X in I2.

Can anyone point me in the right direction here?

[3fingersalute]

This seems like a simple question but it's not from what I can see.

I want to have a field display an X of anything in 4 other fields is a number above 70.

I.E. - If E2 or F2 or G2 or H2 are > 70 make an X in I2.

Can anyone point me in the right direction here?

You could use the conditional formatting found under the format menu I believe.

[TechZ]

NooNoo is a genius in Excel, she's got the skills to sort this out.

[3fingersalute]

Wait - scratch that, that will only format the cell, not display certain text.

[kato2274]

VBA for excel might also be a nice option if you can program the least littlest bit in VB

[3fingersalute]

Use the insert function, and then use the if function.

[kato2274]

Use the insert function, and then use the if function.

if function works great for simple if then else statements. I use it alot for simple if statements like

=if(c2-1,c3="yes",c3="no")

so if c2 =1 then c3 = yes else c3 = no

you MIGHT be able to use the if function with a ton of nested else if, but the function would be pretty cumbersome IF it would work ()

with what ILTU wants to do you'd need the ability to include the OR operator.

VBA code in a sheet macro would be the best solution IMO

if c2 = 1 or c1 = 1 then
c3 = yes
else
c3 = no
end if

much cleaner

[hudsonsmith]

=if(or(a1>70,b1>70,c1>70,d1>70),"x","")

[ilovetheusers]

=if(or(a1>70,b1>70,c1>70,d1>70),"x","")

OMG this works perfectly!!!!!!!! You are the man!!!!!!!!!!!!!!!!!!!!!!!!