Top "Formula" questions

Method for evaluating math expressions in Java

In one of my projects I want to add a feature where the user can provide in a formula, for …

java math formula

Nested iif with multiple conditions SSRS

I need to write a formula for a SSRS report. I am not for sure about the exact syntax, but …

vba reporting-services formula iif

How to define a non continuous range in COUNTIF

A B C 1 Β Β 2 Β Β 3 Α Α 4 Α Α 5 Β Β 6 Α Α 7 Α B 8 Β Β 9 Β Β 10 Α Α 11 Β A 12 Α Α 13 Α Α 14 Β Β 15 Α Α 16 Β ?? In cell B16 I want to count how many "B"s (the value in A16) …

excel formula

Filter to show only duplicate entries in Excel 2010

I have two files: Old and New. I need to remove any entry that Old contains from New. So I've …

excel filter duplicates formula

What is a formula to get a vector perpendicular to another vector?

What is a formula to get a three dimensional vector B lying on the plane perpendicular to a vector A? …

math vector formula algebra

Retrieving Values From Excel Merged Columns

I'm doing a hlookup against a value that spans multiple columns. My data is similar to this: A B C …

excel formula excel-formula

Count Unique values with a condition

In column A I have list of different names. In column B, I have values either 0 or 1. I want to …

excel excel-formula formula pivot-table array-formulas

Crystal reports suppression formula with multiple OR operators not working

I am trying to add a very simple suppression formula to my Crystal Report (XI) field but it is not …

crystal-reports formula crystal-reports-xi suppress

Convert light frequency to RGB?

Does anyone know of any formula for converting a light frequency to an RGB value?

algorithm language-agnostic rgb formula approximation

index match returns 0 for blank cell, want it to be "-"

I have looked all over and tried a bunch of different things and non are working. I can get the …

excel formula