Forum Discussion

miro-subasic's avatar
miro-subasic
Copper Contributor
Nov 26, 2022

help with IF formula

Dear community, can somebody help me the following issue? My if formula: =IF(accounts[@[Product ACV]]>1000000,"T","F") works fine. With this I get T or F. However when I use this =IF(accounts[@[Pr...
excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 11, 2022

Hi miro-subasic 

 

It's highly probable the cell where you intially enterred your formula is formatted as Text:

  1. Select the cell that contains your formula
  2. From the Home tab > Clear all
  3. Re-enter your formula

If still not good please upload & share your sample worbook with i.e. OneDrive, Google Drive... then paste the shared link here