Hi,
I have a file in which F9 has the value subtracted from E9 - D9.
C9 has a value either "M" or "SF"
Cell H9 has the following formula
I need the formula if C9 = "M" then the above formula should be applied.![]()
Please Login or Register to view this content.
If C9 = "SF" then the following formula should be implemented.
I tried AND and OR logics but couldn't sort it out.![]()
Please Login or Register to view this content.
Somebody please guide me.
Thanks in advance.
I have attached my file.
Bookmarks