Hi, I am looking to perform two functions in one cell.
A1=4, B1=16, B1-A1=12
1. Cell C1 should not be more than 8 if value is "C1<=8"
=IF(C1<=8,D1,8)
2. But at the same time what if the value in C1>8, for example 7.5 or 5. I want that value to be displayed in D1. So value less than or equal to 8 should be the outcome in D1.
I await help asap
A1=4, B1=16, B1-A1=12
1. Cell C1 should not be more than 8 if value is "C1<=8"
=IF(C1<=8,D1,8)
2. But at the same time what if the value in C1>8, for example 7.5 or 5. I want that value to be displayed in D1. So value less than or equal to 8 should be the outcome in D1.
I await help asap