"Elkar" wrote in message
...
You could try this:

=IF(INT(AA16)=27,ROUND(M16*.01,2),0)

The Op's data was 27% so INT() will always return zero

I would suggest:

IF(FLOOR(AA16,1%)=27%,ROUND(M16*.01,2),0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk