Hi,
Can anyone help me how to assign conditional formula in excel 2007. Its like i've variables viz., 1.2, 1.5, 0.7, 0.9, 1.1 & 0.8 in column A (A1-A6) and in column B (B1-B6) i should get the same values if it is <1 and if it is 1 or >1 it should come as 1. Finally the values will be 1.0, 1.0, 0.7, 0.9, 1.0 & 0.8.
Bookmarks