Search results

Thank you so much!

is there a way to update the date in a cell that has text also and show it as a date formate for the date part I have a Cell that i have to update the date part of the text daily. EX Completed Loans 7/18/13 I got it to work with ="Completed Loans"&" "&Today() but it comes up as Completed...

to clarify if needed i what the formula to do this: if cell F2 = "Stewart" and cell BJ2 doesn't = "MFC" and cell BN2 = "#N/A" or if cell F2 = "Stewart" and cell BJ2 = "MFC" and cell BN2 = "#N/A" and BO2 doesnt="#N/A" true = "Y" false - "N"

i wasn't worried about the amount of nested items but more the the ability to do a if statement that has a Or and a And within it. the formula that i am tryng that isn't working is as such...

Can you do a If or with a If and nested in it? So i am thinkig it would be something like this if it is possible: =IF(OR(And(first condition, second condition, …, etc)),If(and(first condition, second condition, …, etc)),Y,N)

I have a array for my chart and since I am using a formula even though the it shows a blank it still inputs a 0 opn the chart. Is there anyway i can make it so it doesn't show the 0 on the chart when it should be blank?

Thank you Deb that is exactly what i needed you are a life saver!

I am doing a Vlookup and it is returning 0 if there is a blank for that date but i want it to return the blank so when i take the average the blanks are not lowering the average with the zeros Any help would great Thank you.

Is there are way to drag a vlookup formula so that the Lookup_Value field stays the same but the Col_index_num increases as you drag the formula?

Hello I am tryign to figure out the best way to show my data in a dashboard view. I have 100 or so associates that I score their production and quality. I am currently just using a pivot but would like to come up with something better and more pleasent to the eye like in a dashboard view where...