If result if negative then return value 1

[BrutalLogiC]

Hey I'm wondering what formula to enter into a cell where I want it to return the value 1 when the cell it is looking at is a negative number?

Also.. if the cell it is looking at is positive I want it to do -Q25/R21.. if that's possible!?

Thanks!

 

[AhoyNC]

Like this?

Excel Workbook
	A	B
1	1	-5
Sheet

 

[Legacy 143009]

Let say, your are going to check A1. Then;

=IF(A1<0,1,Q25/R21*-1)

Have a nice day

 

[BrutalLogiC]

Thank you both! Superb forum once again.