Forum Discussion
Solved
IF statement
Should be a simple formula, but I'm getting errors. I have a spreadsheet with numerical values that depend on each other. Example of a problematic formula: =IF(D4>G3,(D4-G3)*90%,0) does not work. E.g...
=HVIS(D4>G3;(D4-G3)*90%;0)This is the formula for Norwegian Excel.
=WENN(D4>G3;(D4-G3)*90%;0)This is for german Excel. I didn't know which version you work with therefore i translated the formula into english.
A closer look tell me that you have used =WENN instead of If. But that did not help me either. I use norwegian and WENN is not recognized, but IF is.
=HVIS(D4>G3;(D4-G3)*90%;0)This is the formula for Norwegian Excel.
=WENN(D4>G3;(D4-G3)*90%;0)This is for german Excel. I didn't know which version you work with therefore i translated the formula into english.
- Ops. Thought I answered it.
The case fixed. The failure was "," instead of ";"
Thanks to Quadruple_Pawn