Excel IF function Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1874007%22%20slang%3D%22en-US%22%3EExcel%20IF%20function%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1874007%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22container-fluid%22%3E%3CDIV%20class%3D%22chat-wrapper%20in-browser%20row%22%3E%3CDIV%20class%3D%22chat-container-flex%20show-messages%20col-lg-6%20col-lg-offset-3%20col-md-8%20col-md-offset-2%20col-xs-12%22%3E%3CDIV%20class%3D%22chat-container%20form-group%22%3E%3CDIV%20class%3D%22chat-boarder-lines%20chat-bubble-outgoing%20col-xs-8%20col-xs-offset-4%22%3E%3CDIV%20class%3D%22chattext-outgoing%22%3E%3CP%20class%3D%22chattext-body%22%3EI%20am%20struggling%20with%20the%20IF%20function%2C%20I%20have%20followed%20the%20instructions%20for%20the%20function%20but%20yet%20it%20is%20returning%20all%20%22Yes%22%20values%20to%20the%20processing%20fee%20category%2C%20which%20is%20incorrect.%20The%20formula%20is%20as%20follows%3A%20%3DIF(G4%26lt%3B%226%2C000%22%2C%20%22Yes%22%2C%20%22No%22)%20and%20I%20have%20tried%20%3DIF(G2%26lt%3B%226%2C000%22%2C%22Yes%22%2CIF(G2%26gt%3B%226%2C000%22%2C%22No%22))%20and%20still%20is%20not%20producing%20the%20correct%20results.%20I%20am%20not%20sure%20how%20to%20fix%20this%20as%20I%20have%20tried%20many%20variations%20with%20the%20same%20results.%20Can%20you%20advise%3F%3C%2FP%3E%3CP%20class%3D%22chattext-body%22%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22container-fluid%22%3E%3CDIV%20class%3D%22chat-wrapper%20in-browser%20row%22%3E%3CDIV%20class%3D%22chat-container-flex%20show-messages%20col-lg-6%20col-lg-offset-3%20col-md-8%20col-md-offset-2%20col-xs-12%22%3E%3CDIV%20class%3D%22chat-container%20form-group%22%3E%3CDIV%20class%3D%22chat-boarder-lines%20chat-bubble-outgoing%20col-xs-8%20col-xs-offset-4%22%3E%3CDIV%20class%3D%22chattext-outgoing%22%3E%3CP%20class%3D%22chattext-body%22%3EThese%20are%20the%20instructions%20I%20am%20basing%20it%20off%20of%20If%20a%20monthly%20loan%20payment%20is%20less%20than%20%246000%2C%20the%20company%20would%20charge%20a%20processing%20fee%20of%20%24150%3B%20otherwise%2C%20there%20would%20be%20no%20processing%20fee.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am struggling with the IF function, I have followed the instructions for the function but yet it is returning all "Yes" values to the processing fee category, which is incorrect. The formula is as follows: =IF(G4<"6,000", "Yes", "No") and I have tried =IF(G2<"6,000","Yes",IF(G2>"6,000","No")) and still is not producing the correct results. I am not sure how to fix this as I have tried many variations with the same results. Can you advise?

 

These are the instructions I am basing it off of If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee.

0 Replies