Help with 2 IF forumula's

[DB200293]

Hello I am trying to combine 2 IF formula but keep getting an error and looking for some guidance.

Basically what I am trying to do is do IF A - B = 0 then C Otherwise IF D+A=B then C.

The formula i have come up with is =IF($K$7-AM5=0,$P$7,"-"),IF($I$7+$K$7=AM5,$P$7,"-")

Could someone please give me some pointers as to why this formula is not working.

Any help would be greatly appreciated.

Thanks

[alansidman]

=if(($k$7-AM5)=0,$P$7,if(($i$7+$K$7)=AM5,$p$7,"-"))

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[DB200293]

Thank you very much for your help! this has solved the issue!

[chief_abound]

Note please.

Snap151.jpg