Printable View
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.Quote:
Originally Posted by ilovetheusers
NooNoo is a genius in Excel, she's got the skills to sort this out.
Wait - scratch that, that will only format the cell, not display certain text.
VBA for excel might also be a nice option if you can program the least littlest bit in VB
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 likeQuote:
Originally Posted by 3fingersalute
=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 (https://forums.windrivers.com/images.../2007/09/1.gif)
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
=if(or(a1>70,b1>70,c1>70,d1>70),"x","")
Quote:
Originally Posted by hudsonsmith
OMG this works perfectly!!!!!!!! You are the man!!!!!!!!!!!!!!!!!!!!!!!!