Having trouble creating an if formula in excel that will produce a Value rather than what is being typed into the quotes

=IF(Delivered!G10>0, “Complete”, “=D10-Counts!F10”) this is the formula that I have so far. The first part of the formula is fine it is the second part. If the value is less than 0 I would like the formula to produce a value instead of it saying what is in the quotes. Is this possible?

  • PowerPivot: 3 step relation ship
  • How to copy and paste embedded multiple worksheets from one excel file into multiple pages of word document?
  • PHP Access Control Error and JSON Formatting
  • Count columns based on date range
  • Exporting to Excel with the help of C# in Asp.net Web Forms gives me error “Invalid File extension”
  • Load Excel file with long cells via SAPGUI
  • One Solution collect form web for “Having trouble creating an if formula in excel that will produce a Value rather than what is being typed into the quotes”

    Do not put it in quotes and remove the =:

    =IF(Delivered!G10>0, "Complete", D10-Counts!F10) 
    
    MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.