Nov 13 2021 09:01 AM
The question is In H7, Calculate the Insurance amount IF the Condition is ONLY Excellent.
But when I apply the condition it gives me an error. kindly solve it.
Nov 13 2021 09:10 AM
Nov 13 2021 11:20 PM
@RanaNaimat Try this:
=IF([@Condition]="Excellent",[@[Appraised Value]]*Insurance,0)