I have a spreadsheet which calculates the values below 50 and above 50. I need to run data through the calculations
if the values is 82 the Criteria is
IF(50>=7.95)
IF(50<=6.95)
A1=82
=IF(A1>=50,A1*7.95,A1*6.95)
i couldn't find the below values in the above formula. please guide me how to proceed on this
82-50=32
50*6.95=347.5
32*7.95=254.4
i need a formula for this if anyone found please mail to my id
I would like my results to be on Sheet 1 on the same row after all the data.
Can anybody help?
Bookmarks