Amending the Formual

[Blackwell]

Hi,

The formula I have for reducing the VAT has worked out well, but if you put 2 or 3 into the cell "E"3" then it creates a wrong value. What formual can I use so that you can only put in 1 or 0 into cell "E3".

Formula ='Daily Cash Takings'!F8/(1+(E3*0.175))

Thanks, Blackwell

 

[schielrn]

You can use data validation on the cell and set it to only allow a whole number within 0 to 1. Hope that helps.

 

[Andrew Poulsom]

Try:

='Daily Cash Takings'!F8/(1+((E3>0)*0.175))

 

[Blackwell]

Thanks Andrew, schielrn,

They both work well, it gives me two options great.

Thanks