These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

If Statement Mayhem
Author
Previous Topic Next Topic
Mortaliton
Industrialist and Manufacturers Directorate
#1 - 2011-11-07 21:05:19 UTC  |  Edited by: Mortaliton
[url]=IF(Table21[@min]=0,IF(Table20[@min]=0, “N/A”, Table20[@min]),IF(Table20[@min]=0,”N/A”,IF(Table21[@min]< Table20[@min], Table21[@min], Table20[@min])))[/url]

I've been working on a formula that checks to see what price is lower and choses it. The prices checked come from xml updates so i know where to get it. After much thinking and multiple headache pain relievers I finaly made a formula that works. Only problem is it doesn't return my "N/A". it gives me a #NAME? error

any ideas before i headbutt my computer?

Mort.

only way to paste it was in url format. sry

Solved

[url]=IF(Table21[@min]=0,IF(Table20[@min]=0, “N/A”, Table20[@min]),IF(Table20[@min]=0, Table21[@min],IF(Table21[@min]< Table20[@min], Table21[@min], Table20[@min])))[/url]
Tonto Auri
Vhero' Multipurpose Corp
#2 - 2011-11-08 00:16:04 UTC
1. [ code ] block
2. #NAME error means you're referring to a cell name that does not exist.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison