Thanks, but is it possible to make one formula instead of two step.
On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote:
>
> I see the answer in 2 steps, as attached
>
> IF & SUMIF
>
> Regards
> Nitin
>
>
>
> On Saturday, February 23, 2013 4:
Dear Sir,
I have a data in Range (C2:C50). There are values. I want to sum all
value upto or equal to 6500, wherein values greater than 6500 will be
treated as 6500. Kindly help me for formula.
Regards,
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,D