Add extra value on if condition

**bluepomme** · 07-09-2019, 04:30 PM

hello i have a formel that that show if there is money missing if amount is 149 or less

Formula:

Please Login or Register  to view this content.

can you add a extra value to it to show how much is the difference like (FALTANTE + e12-150)

thanks

**AliGW** · 07-09-2019, 04:37 PM

Do you mean this?

=SI(E31>149,"","(FALTANTE "&E12-150&")")

**bluepomme** · 07-09-2019, 05:08 PM

thanks for your help it works as needed

thank you

**AliGW** · 07-10-2019, 12:50 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: Add extra value on if condition