Quattro Pro spereadsheet conversion

[nighttrain20]

I have an NFL spreadsheet the family & I have been using for over 20 years I created in Quattro Pro. they are bugging me to convert it to Excel. There are a couple of formulas I need help with.

The 1st one is: IN QUATTRO PRO ...... @Array(@IF(@ISBLANK(J10),"",@IF(J10>L10,A10,N10))) .....we assign points to our favorite teams and if that team wins the formula fills in the points on your behalf. if you team loses you get 0.

2nd on is : How to make the cell of the winning teams points change to a color,

I would upload the sheet if anyone has QPW but I don't see a way to upload it.

Thank you in advanced,

Tony

 

[Scott T]

You cannot upload a sheet to the forum but you can host it on dropbox or other site and post a link to it. Not sure how many people have Quattro Pro though.

Try

=IF(ISBLANK(J10),"",IF(J10>L10,A10,N10))

 

[rlv01]

Quattro Pro? Wow. There's a name I have not heard in a while. I used to have a copy a million years ago. I'm amazed that it's still in use

 

[nighttrain20]

Yeah, My father in law used it at Chrysler and put a spreadsheet together for us to use for the NFL.